Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

not in

hemant_kNov 24 2021 — edited Nov 24 2021

hi
I have a query where in I have used 'not in ' construct
It takes a lot of time ..
any other way to get the result faster?
e.g.
select custno from cust_mast where custno not in (select custno from other_mast)
please help

This post has been answered by hemant_k on Dec 12 2021
Jump to Answer

Comments

Post Details

Added on Nov 24 2021
9 comments
210 views