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 ... 
commit;

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

You could also use an EXISTS or IN statement, like

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

Leave a Comment