Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle AS Clause      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: AS

Definition:
The AS Clause allows users to specify an alias name for items in a SELECT statement. The alias name will be returned as the column heading in the query result instead of the actual column name.

This is often done as type of "shorthand" to make a query more readable, to to format the output for a specific use.

Example Syntax:

SELECT LastName AS "Last Name"
FROM users;


Related Links:

Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 44 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?