Jun 28, 2016 02:58 PM|pn_nq|LINK
i have a id list in text file. let say id
111,222,333 in the text file
how can i find out the id which is not in the table_a from the list in text file? (not using temp table).
below is my script but it seems very poor performance and wait for a long time, it can't be stop.
select id from (select id from table_a union
select 111 from dual union
select 222 from dual union
select 333 from dual) alldata where id not in (select id from table_a);
any reference code that can be improve the above script so that i can select the required id in oracle. (unix platform)
if the script is executing and wait for a long long time it still can't be stop, what should i do? is it any process locked? or dead lock already?
i don't know the problem is from the script or just DB problem?