Answer Posted / Meenakshi Yadav
In Oracle SQL, you can use the COALESCE function to replace NOT IN with NOT EXISTS. Instead of NOT IN (SELECT column_name FROM table), you can write: SELECT * FROM table WHERE COALESCE(column_name, NULL) IS NOT NULL.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
