Maximum Number of times we can query an oracle database [closed]

I think you want to create a small table of object names and then join, something like:

create table objectnames
  name varchar2(100)

-- populate objectnames
-- could be from a file or another table or whatever
insert into objectnames ... 

-- query from tables
select a.* 
from abc_table a, objectnames o
where a.objectname =

You could also use an EXISTS or IN statement, like

select *
from abc_table
where objectname in (
  select name
  from objectnames

Browse More Popular Posts

Leave a Comment