How to search in all tables?

I want to search a keywork from all tables,all columns,how to do?

Write a pl/sql procedure/function.

I want to know the detail.
in function,should I query each table,each column?It's too complict.and I think it's too slowly.
I established a web with jsp and oracle.I want to achieve the function to search in all web site and databases with a keyword.In other word.Web Search Inside.
My english is poor.I can't show my means clearly.
Would you tell me?
thanks very much.

Sorry buddy, you have to be clear in what you want. If you didnt understand what you have written then how can you expect others to understand.

By the way I cant understand why should you search in all tables and all fields for a value??????? Checkout your database design. Looks like you have to revise it.

I can use full text search in sql server and I can use index server to search a keyword from static web site at windows. But how to do at solaris.How to use full text search in oracle?

I don't think this is possible in Oracle as standard, you will need to write a procedure. Although I agree with the previous posters that I think you need to reconsider your design.

Regards

Use Intermedia cartridge.

http://otn.oracle.com/docs/products/...a77063/toc.htm