0

Suppose I'm using Oracle SQL and I want to find out which columns in the database have these values:

FIM
FIM
FIM
FNP
FJH

What I do know is that it was designed using the eBusiness suite(I think it was Oracle Reports). So I can use eTRM to narrow down.

But can I just use a stored procedure( like this question ) to find where the values are?

thanks

Community
  • 1
  • 1
Caffeinated
  • 11,982
  • 40
  • 122
  • 216

1 Answers1

2

Sounds to me like you have a couple of options. Create a SOLR index based off of your database and query against that OR you can use Oracle Text. My personal recommendation is to use SOLR and remove excess load from your database, that of course is preference and YMMV.

Woot4Moo
  • 23,987
  • 16
  • 94
  • 151
  • Hmm, I don't believe I can do the SOLR( i don't have admin priv.) . so I will look at Oracle Text. thanks – Caffeinated Dec 05 '13 at 14:23
  • 1
    @Adel you shouldn't need admin to run SOLR. It comes with an embedded application server (Jetty) and you can at least prototype the work. – Woot4Moo Dec 05 '13 at 14:24