Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output

Oracle SQL 12c    |    Beginner
  • 13 videos | 1h 10m 40s
  • Includes Assessment
  • Earns a Badge
Likes 33 Likes 33
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.

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 case conversion functions in a SQL statement
    use character manipulation functions in a SQL statement
    use nesting functions in a SQL statement
    use 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 the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
    use arithmetic operators with dates in a SQL statement
    use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statement
    use the numeric ROUND and TRUNC functions with dates
    write a SQL statements that use character, number, and date functions

IN THIS COURSE

  • 5m 19s
    Learn how to identify the types of SQL functions in a SQL statement and describe how they work. FREE ACCESS
  • 2m 12s
    Learn how to use character functions in SQL statements. FREE ACCESS
  • Locked
    3.  Case Conversion Functions
    3m 29s
    In this video, find out how to use case conversion functions in SQL statements. FREE ACCESS
  • Locked
    4.  Character Manipulation Functions
    9m 45s
    Learn how to use character manipulation functions in an SQL statement. FREE ACCESS
  • Locked
    5.  Nesting Functions
    5m 5s
    In this video, you will use nested functions in a SQL statement. FREE ACCESS
  • Locked
    6.  Numeric ROUND and TRUNC Functions
    6m 47s
    In this video, you will learn how to use the numeric ROUND and TRUNC functions in a SQL statement. FREE ACCESS
  • Locked
    7.  MOD Function
    3m 29s
    To find out how to use the MOD function in a SQL statement, consult a SQL reference guide or search for an online tutorial. FREE ACCESS
  • Locked
    8.  Working with Dates and the RR Date Format
    4m 54s
    In this video, find out how to work with dates and the RR date format in SQL. FREE ACCESS
  • Locked
    9.  SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP
    5m 27s
    In this video, learn how to use the SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
  • Locked
    10.  Arithmetic Operators in Dates
    3m 7s
    In this video, you will use arithmetic operators with dates in SQL statements. FREE ACCESS
  • Locked
    11.  Date Manipulation Functions
    7m 16s
    In this video, you will use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in an SQL statement. FREE ACCESS
  • Locked
    12.  Using Numeric ROUND and TRUNC Functions with Dates
    4m 11s
    Find out how to use the numeric ROUND and TRUNC functions with dates. FREE ACCESS
  • Locked
    13.  Exercise: Use Character, Number, and Date Functions
    9m 40s
    In this video, you will learn how to write SQL statements that use character, number, and date functions. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Likes 33 Likes 33  
Course Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Likes 25 Likes 25  
Course Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 70 Likes 70  
Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Likes 75 Likes 75  
Course Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions
Likes 25 Likes 25