「Oracle入門」sqlplusの実行結果をCSVに出力する方法
操作コマンド
set echo off set linesize 500 set pagesize 0 set feedback off spool 'c:\user.csv' SELECT USENAME ||','|| AGE ||','|| HOBBY ||','|| EMAIL||','|| MEMO FROM USERTBL; spool off exit;
Coding Changes the World
操作コマンド
set echo off set linesize 500 set pagesize 0 set feedback off spool 'c:\user.csv' SELECT USENAME ||','|| AGE ||','|| HOBBY ||','|| EMAIL||','|| MEMO FROM USERTBL; spool off exit;