SQL: My Oracle quick reference
SET PAGESIZE 400
SET LINESIZE 120
SPOOL C:\TEMP\FILENAME.TXT
SPOOL OFF
ED
SAVE -> ALT-F4
/
SELECT * FROM TAB
SELECT MAX(LENGTH FIELDNAME) FROM TABLE
COLUMN FIELDNAME FORMAT A25 (FOR TEXT)
You might also be interested inLeave a Reply
