Toad World® Forums

Creating Temporary Tables

#1

Hello,

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

(FIELD_NAME INT/VARCHAR(50)/DECIMAL)

ON COMMIT PRESERVE ROWS**;**

then

INSERT INTO TABLE_NAME VALUES (?)

then you select your text file which holds the unique IDs, and it imports those into the table.

#2

Might I suggest simply

  1. Creating a table with the appropriate attributes you need within Toad (e.g. “New table” tool bar button, defining column names you need, data types, etc.),
  2. Using Toad’s Import Wizard to import your data values,
  3. Running your multi-join query involving this table with the other tables
  4. Deleting your “temp” table when done.