How to find data in whole table

[venkat_orasphere]

Hi,

Can anybody help me out

I want to find the data in a table but here i dont know the data available in which coloumn.

I.e my table consist 100 rows(records) with 500 coloumns. now i would like to find one column data(eg.. RAM) i dont know in which column it is avialble.. now how i wil find the data


plz give the solution for this

[amirtai]

I would say your answer is hidden in Oracle Text search i.e standard CTX_DDL. If you have different types of columns (CLOB,BLOB etc) that may contain PDF, RTF Documents etc then you should consider using Oracle Ultra search capabilities.

Thanks
Amir

[kareem2003]

Just i know how to findout the column command is
SELECT * FROM ALL_TAB_COLUMNS
wtire the wHERE condition like i find out TYPE_LOOKUP__CODE
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE 'TYPE_LOOKUP_CODE'

then u can find out the TABLE NAME
have a nice day and
HAPPY NEW YEAR.