I am new to TOAD for the most part; as I mostly work within Teradata SQL Assistant. However I need to work in TOAD for this Oracle database so my question is; can you create temporary tables in TOAD.
For instance, I have a list of 30,000 unique ID’s, and I want to upload those IDs into TOAD somehow (temp table) so I can extract data for those 30,000 accounts only using other tables.
This is possible in Teradata SQL Assistant by using;
CREATE VOLATILE TABLE TABLE_NAME
ON COMMIT PRESERVE ROWS**;**
INSERT INTO TABLE_NAME VALUES (?)
then you select your text file which holds the unique IDs, and it imports those into the table.