Title: (Optional) Incorporate column alias and literals in a SELECT statement.
Course: Database Design and Management (Oracle) (10052) > Section: Writing Structured Query Language (SQL) Statements

Incorporation should include distinguishing between single- and double-quoted text and how each will be treated by the database, and should include

- the three ways to define column aliases and how the column_name will be presented in the ResultSet:
  - Plain text directly after the column name:
    - SELECT column_name alias, column_name2, …
  - Plain text with double quotes directly after the column name:
    - SELECT column_name “Alias”, column_name2, …
  - Using the “as” operator with double-quoted text directly after column_name:
    - SELECT column_name as “Alias”, column_name2, …
- outputting string literals using the single quote in SELECT clause and describing how it will be presented in the ResultSet:
  - SELECT column_name, ‘String Literal’, column_name2, …