Find all Columns and Tables having a particular data plsql

April 17, 2019 at 06:14:09
Specs: DOS
In a Oracle Database I need to report all the Columns (along with tables) which have particular data in them.

Like all the columns having the string 'Modelx'.

Tried with a cursor built on ALL_TAB_COLS but it throws error as ORA-29400: data cartridge error


Thanks in advance for help


See More: Find all Columns and Tables having a particular data plsql

Reply ↓  Report •
Related Solutions


Ask Question