ora15

-- dump_full_row_READABLE_FIX.sql
-- ONE LINE → ALL COLUMNS → FIX MESSAGE WITH | instead of SOH
SET HEADING OFF FEEDBACK OFF PAGESIZE 0 TRIMSPOOL ON TRIMOUT ON LINESIZE 32767 COLSEP ""

SPOOL ORACLE_FULL_ROW_READABLE.txt

SELECT
/* 01 / NVL(TO_CHAR(INTERNIDENTITY),'') || '~' ||
/ 02 / NVL(TO_CHAR(INTERNINSTID),'') || '~' ||
/ 03 / NVL(TO_CHAR(INTERNVERSION),'') || '~' ||
/ 04 / TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS:FF3') || '~' ||
/ 05 / NVL(TO_CHAR(INTERNRECTYPE),'') || '~' ||
/ 06 / REPLACE(
CONVERT(
DBMS_LOB.SUBSTR(INTERNFIXSTRING, DBMS_LOB.GETLENGTH(INTERNFIXSTRING), 1),
'AL32UTF8', 'AL32UTF8'
),
CHR(1), '|' -- ← SOH → |
) || '~' ||
/ 07 / NVL(ORDERID,'') || '~' ||
/ 08 / NVL(ACCOUNT,'') || '~' ||
/ 09 / NVL(MERGEID,'') || '~' ||
/ 10 / NVL(PARENTORDERID,'') || '~' ||
/ 11 / NVL(SALESPERSONID,'') || '~' ||
/ 12 / NVL(SYMBOL,'') || '~' ||
/ 13 / NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'),'') || '~' ||
/ 14 / NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'),'') || '~' ||
/ 15 / NVL(TO_CHAR(LEAVESQTY, 'FM99999999999999999990.999999999999'),'') || '~' ||
/ 16 */ NVL(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