ORACLE: Generating CSV output

CSV output to file

set linesize 130

set pagesize 0

set echo off

set wrap off

set heading off

-- get databases users

-- output to file in the same directory as where you have opened SQL*Plus

spool database_users.csv

select u.user_id || ',' || u.surname || ',' || u.forenames

from user u,

where LOWER(u.user_id) like '%a%'

spool off