This course assumes that you are familiar enough with SQL to write basic queries, including queries that take advantage of these SQL features:
Joining two or more tables
Grouping and summarizing data
This module covers some advanced SQL features, such as hierarchy queries and combining multiple queries with the
In addition, you will try out some query features that are exclusive to Oracle, such as the use of pseudocolumns
A pseudocolumn is a special column generated when Oracle executes the query. There are a number of pseudocolumns, as you will see in this module.
A pseudocolumn is data that Oracle makes available to you when it executes SQL commands.
These are created for convenience. For example, the Oracle user name that is executing the SQL is contained in the pseudocolumn called USER.
The next lesson discusses operators and conditions that are not usually covered in introductory SQL courses.