Skip to content

Instantly share code, notes, and snippets.

@donchan922

donchan922/demo.sql

Last active August 6, 2020 09:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save donchan922/ffaf31b7301dd9382d33843c0fc5aefd to your computer and use it in GitHub Desktop.
Save donchan922/ffaf31b7301dd9382d33843c0fc5aefd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
demo.sql
alter session set nls_date_format="YYYY/MM/DD HH24:MI:SS";
set echo off
set termout off
set pagesize 0
set linesize 1000
set trims on
set feedback off
spool output.csv
SELECT
id ||','||
name ||','||
created_at
FROM
user
spool off
exit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment