Customizing Output

Oracle 12c    |    Beginner
  • 13 videos | 57m 7s
  • Earns a Badge
Rating 4.7 of 168 users Rating 4.7 of 168 users (168)
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
    In this video, you will learn how to identify the types of SQL functions in a SQL statement and describe single-row functions. FREE ACCESS
  • Locked
    2.  Character Functions
    2m 53s
    In this video, find out how to use character functions in SQL statements. FREE ACCESS
  • Locked
    3.  Case-conversion Functions
    5m 46s
    In this video, learn how to use the case-conversion functions in SQL statements. FREE ACCESS
  • Locked
    4.  Character-manipulation Functions
    4m 38s
    In this video, find out how to use the character-manipulation functions in an SQL statement. FREE ACCESS
  • Locked
    5.  Nesting Functions
    5m 33s
    In this video, learn how to use the nesting functions in an SQL statement. FREE ACCESS
  • Locked
    6.  Numeric ROUND and TRUNC Functions
    5m 51s
    During this video, you will learn how to use the numeric ROUND and TRUNC functions in SQL statements. FREE ACCESS
  • Locked
    7.  MOD Function
    2m 9s
    During this video, you will learn how to use the MOD function in SQL statements. FREE ACCESS
  • Locked
    8.  Working with Dates and the RR Date Format
    3m 44s
    In this video, learn how to work with dates and the RR date format in SQL statements. FREE ACCESS
  • Locked
    9.  SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP
    4m 14s
    In this video, find out how to use the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
  • Locked
    10.  Arithmetic  Operators in Dates
    3m 14s
    In this video, find out how to use arithmetic operators with dates in a SQL statement. FREE ACCESS
  • Locked
    11.  Date-manipulation Functions and using Date Functions
    6m 8s
    After completing this video, you will be able to describe and use the date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statement. FREE ACCESS
  • Locked
    12.  Numeric ROUND and TRUNC Functions with Dates
    2m 43s
    During this video, you will learn how to use the numeric ROUND and TRUNC functions with date values. FREE ACCESS
  • Locked
    13.  Exercise: Use  Character, Number, and Date Functions
    6m 19s
    In this video, you will learn how to write a SQL statement using the CHAR, 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

Channel Oracle Database 12c Administrator Certified Associate
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Conversion
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)
Course Aggregating Data
Rating 4.7 of 152 users Rating 4.7 of 152 users (152)
Course Working with Joins
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)