Customizing Output

Oracle 12c    |    Beginner
  • 13 Videos | 59m 7s
  • Earns a Badge
Likes 53 Likes 53
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.

WHAT YOU WILL LEARN

  • identify the types of SQL functions in a SQL statement and describe single-row functions
    use character functions in a SQL statement
    use the case-conversion functions in a SQL statement
    use the character-manipulation functions in a SQL statement
    use the nesting functions in a SQL statement
    use the numeric ROUND and TRUNC functions in a SQL statement
    use the MOD function in a SQL statement
  • work with dates and the RR date format in a SQL statement
    use SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
    use arithmetic operators with dates  in a SQL statement
    describe and use date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY in a SQL statement
    use the numeric ROUND and TRUNC functions with dates
    write a SQL statement using the CHARACTER, NUMBER, and DATE functions

IN THIS COURSE

  • Locked
    1. 
    Types of SQL Functions and Single-Row Functions
    3m 57s
  • Locked
    2. 
    Character Functions
    2m 53s
  • Locked
    3. 
    Case-conversion Functions
    5m 46s
  • Locked
    4. 
    Character-manipulation Functions
    4m 38s
  • Locked
    5. 
    Nesting Functions
    5m 33s
  • Locked
    6. 
    Numeric ROUND and TRUNC Functions
    5m 51s
  • Locked
    7. 
    MOD Function
    2m 9s
  • Locked
    8. 
    Working with Dates and the RR Date Format
    3m 44s
  • Locked
    9. 
    SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP
    4m 14s
  • Locked
    10. 
    Arithmetic  Operators in Dates
    3m 14s
  • Locked
    11. 
    Date-manipulation Functions and using Date Functions
    6m 8s
  • Locked
    12. 
    Numeric ROUND and TRUNC Functions with Dates
    2m 43s
  • Locked
    13. 
    Exercise: Use  Character, Number, and Date Functions
    6m 19s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
Likes 223 Likes 223  
Likes 46 Likes 46