Exporting to Excel from ORACLE via SQL*Plus

SQL*Plus is commonly used to extract data from an ORACLE database, by simply spooling query results out to a file. Generally by CSV, SQL*Plus extracts can be used for reporting data or viewing meta-data. There are various limitations to extracting to basic CSV however, one particular one being CLOBs; a good way to partially resolve …

Exporting to Excel from ORACLE via SQL*Plus Read More »