ora16

-- dump_full_row_READABLE.sql
SET HEADING OFF FEEDBACK OFF PAGESIZE 0 TRIMSPOOL ON TRIMOUT ON LINESIZE 32767 COLSEP ""

SPOOL C:\temp\ORACLE_FULL_ROW_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(MERGEID,'') || '~' ||
NVL(PARENTORDERID,'') || '~' ||
NVL(SALESPERSONID,'') || '~' ||
NVL(SYMBOL,'') || '~' ||
NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'),'') || '~' ||
NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'),'') || '~' ||
NVL(TO_CHAR(LEAVESQTY, 'FM99999999999999999990.999999999999'),'') || '~' ||
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