Oracle Text (MOSC)

MOSC Banner

Search for a string in entire database tables

edited Jul 22, 2012 10:45PM in Oracle Text (MOSC) 9 commentsAnswered
Hi,

 In our database schema there are around 200 tables (some of them are very huge in size) with multiple text fileds; we want to devlop an application where user can search any text(string) and output should be column name, tablename,column value.

 Looks like there are multiple options in oracle to do text search in database but bit confused which one should opt?

  Oracle Ultra search or  Oracle Text search

Any help on this is appreciated.

Thanks,

Akc

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center