Oracle PL/SQL: SELECT: Using Functions - SELECT allows the use of functions within its scope, as shown by the use of TO DATE() here to conver

Quick Search:

Oracle PL/SQL: SELECT: Using Functions

Jump to:

Category: >> Oracle PL/SQL >> SELECT: Using Functions

<< last

next >>

Snippet Name: SELECT: Using Functions

Description: SELECT allows the use of functions within its scope, as shown by the use of TO_DATE() here to convert a timestamp associated with a user record. The use of SUM() is also shown.

Also see:
» TABLE: Using Select Statement With Data
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Get DISTINCT or UNIQUE values
» SELECT: Get UNIQUE and DISTINCT values
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

SELECT <date_function(<column_name>))
FROM <table_name>;
 
SELECT <numeric_function(<column_name>))
FROM <table_name>;
 
SELECT <string_function(<column_name>))
FROM <table_name>;
 
 
SELECT first_name, TO_DATE(TIMESTAMP, 'YYYY-MM-DD:HH24:MI:SS')
FROM user_list
WHERE ROWNUM < 11;
 
 
SELECT SUM(bytes)/1024/1024 USED_MB
FROM user_extents;
 
SELECT segment_type, SUM(bytes)/1024/1024 USED_MB
FROM user_extents
GROUP BY segment_type;