Chap05 - Chapter 5 Selected Single-Row Functions Chapter 5 Introduction to 1 Chapter Objectives Use the UPPER LOWER and INITCAP functions to change

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5 Introduction to 1 Chapter 5 Selected Single-Row Functions
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 5 Introduction to 2 Chapter Objectives Use the UPPER, LOWER, and INITCAP functions to change the case of field values and character strings Extract a substring using the SUBSTR function Determine the length of a character string using the LENGTH function
Background image of page 2
Chapter 5 Introduction to 3 Chapter Objectives Use the LPAD and RPAD functions to pad a string to a desired width Use the LTRIM and RTRIM functions to remove specific characters strings Round and truncate numeric data using the ROUND and TRUNC functions Calculate the number of months between two dates using the MONTHS_BETWEEN function
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter 5 Introduction to 4 Chapter Objectives Identify and correct problems associated with calculations involving null values using the NVL function Display dates and numbers in a specific format with the TO_CHAR function Determine the current date setting using the SYSDATE keyword Nest functions inside other functions Identify when to use the DUAL table
Background image of page 4
Chapter 5 Introduction to
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/10/2011 for the course CIS339 NONE taught by Professor None during the Spring '10 term at DeVry Chicago.

Page1 / 35

Chap05 - Chapter 5 Selected Single-Row Functions Chapter 5 Introduction to 1 Chapter Objectives Use the UPPER LOWER and INITCAP functions to change

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online