Converting LONG to CLOB – scaning LONG

SQL manipulation on dba_views column text is impossible because it’s LONG type SELECT view_name, text FROM user_views WHERE text LIKE ‘%SEARCH%’;   SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got LONG 00932. 00000 –  "inconsistent datatypes: expected %s got %s" … Continue reading Converting LONG to CLOB – scaning LONG