format

SET HEADING OFF
FEEDBACK OFF
PAGESIZE @
TRIMSPOOL ON
TRIMOUT ON
LINESIZE 32767
COLSEP ""

SPOOL ./ORACLE_FULL_ROM_READABLE.txt

SELECT
NVL(TO_CHAR(INTERNIDENTITY), '') || '~' ||
NVL(TO_CHAR(INTERNINSTID), '') || '~' ||
NVL(TO_CHAR(INTERNVERSION), '') || '~' ||
TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS:FF3') || '~' ||
NVL(TO_CHAR(INTERNRECTYPE), '') || '~' ||
REPLACE(
CONVERT(
DBMS_LOB.SUBSTR(INTERNFIXSTRING, DBMS_LOB.GETLENGTH(INTERNFIXSTRING), 1),
'AL32UTF8', 'AL32UTF8'
),
CHR(1), '|'
) || '~' ||
NVL(ORDERID, '') || '~' ||
NVL(ACCOUNT, '') || '~' ||
NVL(MERGELD, '') || '~' ||
NVL(PARENTORDERID, '') || '~' ||
NVL(SALESPERSONID, '') || '~' ||
NVL(SYMBOL, '') || '~' ||
NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'), '') || '~' ||
NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'), '') || '~' ||
NVL(TO_CHAR(LEAVESQTY, 'FM9999999999999999999999.9999999999999'), '') || '~' ||
NVL(TIMEINFORCE, '')
FROM CACHECPLSORDER
WHERE TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') = '2012-05-21 19:28:19'
AND ROWNUM = 1;