ora8

-- ==============================================================
-- EXACT Sybase-compatible dump from Oracle
-- Separator: ~
-- Works with your real table structure (from screenshot)
-- ==============================================================

SET ECHO OFF FEEDBACK OFF VERIFY OFF HEAD OFF PAGESIZE 0
SET LINESIZE 32767 TRIMSPOOL ON TAB OFF COLSEP '' TERMOUT OFF
SPOOL C:\temp\CACHECPLSORDER_oracle_dump.txt

SELECT
/* 1. INTERNIDENTITY NUMBER(22) / NVL(TO_CHAR(INTERNIDENTITY), '') || '~' ||
/ 2. INTERNINSTID NUMBER(22,10) / NVL(TO_CHAR(INTERNINSTID), '') || '~' ||
/ 3. INTERNVERSION NUMBER(22,10) / NVL(TO_CHAR(INTERNVERSION), '') || '~' ||
/ 4. INTERNTIMESTAMP TIMESTAMP(6) / NVL(TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF6'), '') || '~' ||
/ 5. INTERNRECTYPE NUMBER(22,10) / NVL(TO_CHAR(INTERNRECTYPE), '') || '~' ||
/ 6. INTERNFIXSTRING CLOB / NVL(DBMS_LOB.SUBSTR(INTERNFIXSTRING, 4000, 1), '') || '~' ||
/ 7. ORDERID VARCHAR2(128) / NVL(ORDERID, '') || '~' ||
/ 8. ACCOUNT VARCHAR2(128) / NVL(ACCOUNT, '') || '~' ||
/ 9. MERGEID VARCHAR2(128) */ NVL(MERGEID, '') || '~' ||
/*10. PARENTORDERID VARCHAR2(128) */ NVL(PARENTORDERID, '') || '~' ||
/*11. SALESPERSONID VARCHAR2(128) */ NVL(SALESPERSONID, '') || '~' ||
/*12. SYMBOL VARCHAR2(128) */ NVL(SYMBOL, '') || '~' ||
/*13. EXPIREDATE TIMESTAMP(6) */ NVL(TO_CHAR(EXPIREDATE, 'YYYY-MM-DD'), '') || '~' ||
/*14. EXPIRETIME TIMESTAMP(6) */ NVL(TO_CHAR(EXPIRETIME, 'HH24:MI:SS'), '') || '~' ||
/*15. LEAVESQTY FLOAT(126) */ NVL(TO_CHAR(LEAVESQTY, 'FM99999999999999999990.999999999999'), '') || '~' ||
/*16. TIMEINFORCE VARCHAR2(128) */ NVL(TIMEINFORCE, '') || '~' ||
/*17. row_hash (MD5) - Sybase-compatible UTF-8 MD5 */
RAWTOHEX(
STANDARD_HASH(
UTL_I18N.STRING_TO_RAW(
NVL(TO_CHAR(INTERNIDENTITY),'') ||
NVL(TO_CHAR(INTERNINSTID),'') ||
NVL(TO_CHAR(INTERNVERSION),'') ||
NVL(TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF6'),'') ||
NVL(TO_CHAR(INTERNRECTYPE),'') ||
NVL(DBMS_LOB.SUBSTR(INTERNFIXSTRING,4000,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,'')
, 'AL32UTF8')
, 'MD5')
)
FROM CACHECPLSORDER
ORDER BY
INTERNIDENTITY, INTERNINSTID, INTERNTIMESTAMP;

SPOOL OFF
SET TERMOUT ON