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;

• Oracle SELECT: Examples Of The AS Clause
• Oracle UPDATE: Examples Of The AS Clause
• Oracle JOINS: Examples Of The AS Clause

• WITH Clause: Double alias - The WITH query_name clause provides a way assign a name to a subquery ...
• WITH Clause: Single alias - The WITH query_name clause provides a way assign a name to a subquery ...
• PHP - connect to an Oracle database - This code connects to an Oracle database defined by TNSNAME,...
• Alias and RowType - This block finds all employees whose monthly wages (salary plus commission) ar...
• Basic FOR LOOP example - This block uses a simple FOR loop to insert 10 rows into a table. The ...
• Log database errors - Logs all database errors to a table. NOTE: DBA or CREATE ANY TRIGGER pri...
• Logarithm to base - Returns the log of a number for any base.
• String Functions: ASCII - Returns the ASCII number code that represents the specified character.
• Last_Day function - The last_day function returns the last day of the month based on a date value.
• Find most active SQL in the last hour - Finds the most active SQL code run in the last hour.
• Database Link - Database Links are used to communicate between different databases. A database ...
• LAST - Returns the row ranked last using DENSE_RANK.
• LAST_VALUE - Returns the last value in an ordered set of values. If the last value in the set is n...
• Verify Password - A function useful in password verification and maintenance.
• Measure the Buffer Cache Hit Ratio - Note that hit ratio based tuning is not recommended.
• Display database SGA statistics - Handy routine to display the database's SGA statistics.
• Display and release DBMS_LOCK locks - Release DBMS_LOCK locks on database.
• Generate ASCII table - Generates the full ASCII table. Useful for reference or decoding, testing, etc.
• Date Functions: LEAST - Returns the earliest date.
• Date Functions: LAST_DAY - Returns the last date (not day) of a given month.
• Create Table INSERT (CTAS) - Create a table with the results from a SELECT statement.
• UPDATE: Update based on a query - Update one or more rows based on the results of a query.
• UPDATE: based on multiple returned values - Update based on multiple returned values from a query.
• UPDATE: Update based on a record - Update a table based on the value or presence of a record.
• ASCIISTR - ASCIISTR takes as its argument a string, or an expression that resolves to a string, in...