Hi,
I need a sql query to check in a cloumn which is a blob data type ,where the column stores the XML values and the query should check a particular value in the column if value is there it shud return with yes or no.

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=***;