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 pages 1–6. Sign up to view the full content.

Chapter 5 Introduction to 1 Chapter 5 Selected Single-Row Functions

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

View Full Document
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
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

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

View Full Document
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
Chapter 5 Introduction to

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

View Full Document
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
Ask a homework question - tutors are online