DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to search in all tables?

  1. #1
    Join Date
    Sep 2001
    Posts
    99

    How to search in all tables?

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

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Write a pl/sql procedure/function.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Sep 2001
    Posts
    99

    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

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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)

  5. #5
    Join Date
    Sep 2001
    Posts
    99

    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

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  7. #7
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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
  •  


Click Here to Expand Forum to Full Width