Amrit Dhaskat February 2016

how to convert long raw data type to readable format(oracle version :11.2.0.3.0) in oracle?

how to convert long raw data type to readable format(oracle version :11.2.0.3.0) in oracle?

Please help me oracle version :11.2.0.3.0 i want to convert long raw data type to readable format

Answers


kevinsky February 2016

I use this code from Adrian Billington. It has versions that work on Oracle 9, 10 and 11 and probably 12.

Essentially the code reads the LONG data and converts it on the fly into a CLOB. You can expose this as a view or select from TABLE(function call)


SkyWalker February 2016

For analyzing LONG value from system views I use PL/SQL. As example:

DECLARE
  CURSOR curs IS
    SELECT p.high_value -- LONG value
          ,p.table_name
          ,p.partition_name
    FROM user_tab_partitions p;
  c         curs%ROWTYPE;
BEGIN
  FOR c IN curs 
    LOOP
      IF c.high_value like '%CD_FEED%'
        THEN dbms_output.put_line(c.table_name);
      END IF;
    END LOOP;
END;

Post Status

Asked in February 2016
Viewed 1,388 times
Voted 8
Answered 2 times

Search




Leave an answer