-
How to search in all tables?
I want to search a keywork from all tables,all columns,how to do?
ocean
-
Write a pl/sql procedure/function.
Agasimani
OCP(10g/9i/8i/8)
-
How to do?
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.
ocean
-
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.
Agasimani
OCP(10g/9i/8i/8)
-
ok
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?
ocean
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|