CoderZone.org

Category: >> Oracle PL/SQL >> Built-In Functions: DECODE Bookmark and Share

<< lastnext >>

Snippet Name: Built-In Functions: DECODE

Description: A type of replacement function within the SELECT statement.

Also see:
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» IN Function
» Built-In Functions: CASE
» SUBST and INSTR together
» INSTR (InString)
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH
» String Functions: INSTR
» String Functions: CONCAT
» String Functions: CHAR
» String Functions: INITCAP
» String Functions: LOWER
» String Functions: UPPER
» Date Functions: NUMTOYMINTERVAL
» Date Functions: NUMTODSINTERVAL

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

SELECT id, 
  DECODE(customer_id, 'AOL', 'America Online') Company,
  order_date
FROM test2
WHERE ROWNUM < 21
/
 
 
SELECT program_id, 
       DECODE(customer_id,
              'AOL', 'America Online',
              'TW', 'Time Warner',
              'ORCL', 'Oracle Corporation',
              'NetApp', Network Appliances',
       order_date
FROM test2
WHERE ROWNUM < 21
/
 
 
decode with default
 
SELECT program_id, 
       DECODE(customer_id,
              'AOL', 'America Online',
              'TW', 'TIME Warner',
              'ORCL', 'Oracle Corporation',
              'NetApp', Network Appliances',
              'OTHER'
       order_date
FROM test2
WHERE ROWNUM < 21
/
 
 
 
 
 
 
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 6