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?