O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we've introduced our first SQL statement, the SELECT statement, examined its syntax, and explored how it can be used in the process of column projection. We've seen the use of the SELECT statement in projecting single columns and multiple columns. We have looked at the DESCRIBE command and how it can be used to display the column names for a table. We've covered the use of aliases in changing column headings and used arithmetic operators to execute mathematical calculations on table data. We've examined the concept of NULL and demonstrated how to retrieve unique rowsets using DISTINCT. Finally, we've used the double pipe symbol to concatenate string literals with table values.

Certification objectives covered

  • Listed the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required