This content has been marked as final. Show 4 replies
You may make use of below queries to get BLOB & XML columns
select OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE from dba_tab_columns where upper(DATA_TYPE) like '%BLOB%'; select * from DBA_XML_TAB_COLS;
Thanks for your reply...
Let me clearly explain my need.. for instance a table xyz and in that we have 5 columns but based on some conditions on 3 columns i need to retrive the records..like..
select * from xyz where a=** and b=** and c=***; here i need to pass the values of a,b and c while runtime only and not as static values and also i need to return with a message like records found,not found based on the condition where the particular record for the column C is there or not there.
You requirement is complicated .
Are you able to write such query on BLOB columns? If yes then run time values can be passed as by declaring as input variable in pl/sql function / procedures
Now , you want to pull records irrespective of column C o/p then where condition should be where ( a=** and b=** ) or c=***;