DEV Community

Query Filter
Query Filter

Posted on

ora12

SELECT
ORDERID,
REPLACE(
CONVERT(
DBMS_LOB.SUBSTR(INTERNFIXSTRING, DBMS_LOB.GETLENGTH(INTERNFIXSTRING), 1),
'AL32UTF8', 'AL32UTF8'
),
CHR(1), '|'
) AS FIX_MESSAGE_READABLE
FROM CACHECPLSORDER
WHERE TO_CHAR(INTERNTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') = '2012-05-21 19:28:19'
AND ROWNUM = 1;

Top comments (0)