20080617 printing a csv from sqlplus output - plembo/onemoretech GitHub Wiki

title: Printing a csv from sqlplus output link: https://onemoretech.wordpress.com/2008/06/17/printing-a-csv-from-sqlplus-output/ author: lembobro description: post_id: 500 created: 2008/06/17 15:11:02 created_gmt: 2008/06/17 15:11:02 comment_status: open post_name: printing-a-csv-from-sqlplus-output status: publish post_type: post

Printing a csv from sqlplus output

Here’s a new skill. I needed to dump a list of users from the Oracle Portal database containing their USER_NAMEs and GUIDs. At first I did it in HTML, and then thought it would be more useful as a csv file.

SQL> set head off SQL> set pagesize 0 SQL> spool mylist.csv SQL> select USER_NAME||','||GUID from wwsec_person$;

Not bad for a measly sysadmin, eh?