The SELECT statement retrieves information from tables.
The SELECT statement specifies the table and a list of column names.
After the SELECT keyword, you supply the column names.
After the FROM keyword, you supply the table name.
The SQL statement is ended using a semicolon (;).
The items that immediately follow the SELECT statement can be any valid expressions.
The rows returned by the database are known as a result set.
Oracle database converts the column names into their uppercase equivalents.
Character and date columns are left-justified.
Number columns are right-justified.
View Complete Post