Search for a string in entire database tables
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