Snippet Name: SQL*Plus formatting
Description: Column formatting in the SQL*Plus application to make reading query results easier.
Also see:
» SQL*Plus Configuration
» SQL*Plus SQL Prompt
» SQL*Plus Spool Command
» SQL*Plus Display commands
» SQL*Plus Describe
» SQL*Plus connect
Comment: (none)
Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009
|
COL object_name FORMAT a30
SELECT object_name, object_type
FROM user_objects
WHERE ROWNUM < 11;
TO format a NUMBER column AS dollars -
COL salary FORMAT $99,999
Display "-" after a negative VALUE
COL test FORMAT 9999MI
Displays a negative VALUE IN <angle brackets>
COL test FORMAT 9999PR
Display the DECIMAL character
COL test FORMAT 9999D99
Display VALUE IN scientific notation
COL test FORMAT 9999.99EEEE
Format a NUMBER columns that represent Julian dates AS MM/DD/YY
COL test FORMAT DATE
|
