Script - Use results of first SQL in subsequent SQL
Hi, my script has about 10 SQL statements. All are very similar pulling different attributes from an oracle db.
Each SQL state has a where clause along the lines of:
WHERE fieldname IN (SELECT FIELD FROM TABLE WHERE STATUS = 1)
Now the embedded Select statement in each where clause is of course quite ineffective. Can I run that SQL statement first and then use the results in the subsequent SQL statements in order to speed up the overall load?