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

Tony Garabedian
Gerd, very true.

That "feature' *is* obsolete, if you noticed the online help still talks about .ico files and not .gif or .png.
Moreover I have tons of icons that ends with the letter N and S both in lowercase and uppercase, so my guess is that the online help was not updated properly.


Tony
657172
yah thats true
1 - 2

Post Details

Added on Nov 24 2021
9 comments
212 views