Sometimes you want to look for data that is not present in your database just to do a differential action without temporary tables. So in order to select values not present in an Oracle table, you need to use the dual option or the sys.dbms_debug_vc2coll option. Let’s cover each option here!

Database - Free of Charge Creative Commons Chalkboard image
Time for some database scripts
Continue reading