Oracle PL/SQL: Simple DUAL examples - DUAL is used for calculations that don't touch tables.

Quick Search:

Oracle PL/SQL: Simple DUAL examples

Jump to:

Category: >> Oracle PL/SQL >> Simple DUAL examples

<< last

next >>

Snippet Name: Simple DUAL examples

Description: DUAL is used for calculations that don't touch tables.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

-- calculate pi:
SELECT 22/7
FROM dual;
 
-- get the character for an ASCII value:
SELECT ASCII(12)
FROM dual;
 
-- get the ASCII value of a character:
SELECT CHR(172)
FROM dual;