1 / 19

Chapter 5 Selected Single-Row Functions

Chapter 5 Selected Single-Row Functions. Terminology. Function – predefined block of code that accepts arguments Single-row Function – returns one row of results for each record processed Multiple-row Function – returns one result per group of data processed. Types of Functions.

tale
Download Presentation

Chapter 5 Selected Single-Row Functions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 5Selected Single-Row Functions

  2. Terminology • Function – predefined block of code that accepts arguments • Single-row Function – returns one row of results for each record processed • Multiple-row Function – returns one result per group of data processed

  3. Types of Functions

  4. Case Conversion Functions Alter the case of data stored in a column or character string

  5. LOWER Function Used to convert characters to lower-case letters

  6. UPPER Function Used to convert characters to upper-case letters

  7. INITCAP Function Used to convert characters to mixed-case

  8. Character Manipulation Functions Manipulates data by extracting substrings, counting number of characters, replacing strings, etc.

  9. SUBSTR Function Used to return a substring, or portion of a string

  10. LENGTHFunction Used to determine the number of characters in a string

  11. LTRIMandRTRIMFunctions Used to remove a specific string of characters

  12. REPLACEFunction Substitutes a string with another specified string

  13. CONCATFunction Used to concatenate two character strings

  14. ROUNDFunction Used to round numeric columns to a stated precision

  15. MONTHS_BETWEENFunction Determines the number of months between two dates

  16. ADD_MONTHSFunction Adds a specified number of months to a date

  17. NEXT_DAYFunction Determines the next occurrence of a specified day of the week after a given date

  18. DECODEFunction Determines action based upon values in a list

  19. NestingFunctions • One function is used as an argument inside another function • Must include all arguments for each function • Inner function is resolved first, then outer function

More Related