Columns « Query Select « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Query Select
  3. Columns
2.8.Columns
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