ora14

-- dump_all_columns.sql
SET HEADING OFF FEEDBACK OFF PAGESIZE 0 TRIMOUT ON TRIMSPOOL ON
SPOOL C:\temp\all_columns_dump.txt
SELECT
ORDERID || '~' ||
TO_CHAR(INTERNINSTID) || '~' ||
TO_CHAR(INTERNVERSION) || '~' ||
TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS:FF3') || '~' ||
TO_CHAR(INTERNRECTYPE) || '~' ||
RAWTOHEX(UTL_RAW.CAST_TO_RAW(CONVERT(DBMS_LOB.SUBSTR(INTERNFIXSTRING, DBMS_LOB.GETLENGTH(INTERNFIXSTRING), 1), 'AL32UTF8', 'AL32UTF8'))) || '~' ||
-- ... all other columns ...
TO_CHAR(LEAVESQTY, 'FM99999999999999999990.999999999999') || '~' ||
TIMEINFORCE
FROM CACHECPLSORDER
WHERE TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') = '2012-05-21 19:28:19'
AND ROWNUM = 1;
SPOOL OFF
EXIT