SELECT Statement, Expressions, & Operators

Oracle 12c
  • 12 Videos | 46m 50s
  • Includes Assessment
  • Earns a Badge
Likes 109 Likes 109
SQL*Plus provides a convenient way to work with Oracle data. Learn to retrieve data using SELECT statements with arithmetic expressions, NULL values, column aliases, and literal strings. In addition, learn how to handle duplicate rows.

WHAT YOU WILL LEARN

  • describe and use the basic SELECT statement
    recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus
    describe and use the arithmetic expressions in SQL
    apply the standard order of precedence in SQL arithmetic expressions
    identify how NULL values are defined in SQL and how they affect arithmetic expression outcomes
    define column aliases in the SELECT list
  • use the concatenation operator to create acharacter expression in the SQL statement output
    use literal character strings in a SELECT statement
    use the alternative quote (q) operator to select a quotation mark delimiter
    eliminate duplicate rows from SQL statement output using the DISTINCT qualifier
    display the structure of a table using the SQL*Plus DESCRIBE command
    select data from different tables, describe tables,  perform arithmetic calculations, and specify column names using aliases

IN THIS COURSE

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.

YOU MIGHT ALSO LIKE

Likes 56 Likes 56  
Likes 18 Likes 18  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 33 Likes 33