| SELECT [hint][DISTINCT] select_list FROM table_list [WHERE conditions] [GROUP BY group_by_list] [HAVING search_conditions] [ORDER BY order_list [ASC | DESC] ] [FOR UPDATE for_update_options] select_list
column1, column2, column3 table.column1, table.column2 table.column1 C_1_Alias, table.column2 C_2_Alias schema.table.column1 Col_1_Alias, schema.table.column2 c_2_Alias schema.table.* * expr1, expr2 (subquery [WITH READ ONLY | WITH CHECK OPTION [CONSTRAINT constraint]]) In the select_lists above, 'table' may be replaced with view or snapshot.
Using the * expression will return all columns. If a Column_Alias is specified this will appear at the top of any column headings in the query output.
| 
