Columns « Query Select « Oracle PL/SQL Tutorial

2.8.1.Selecting All Columns from a Table with asterisk character (*)
2.8.2.Count(*) and column renaming
2.8.3.Expression and column renaming
2.8.4.DISTINCT tableName.*
2.8.5.Combined columns and renaming
2.8.6.Format date value and column renaming
2.8.7.Reference one column more than once
2.8.8.Reference renamed column in order by
2.8.9.Rename case when column

2.8.10.Returning Multiple Columns
2.8.11.Table renaming in from clause
2.8.12.Use table name to reference column name