Passing variable from file to sql from script

Ditto · November 7, 2014, 1:55pm

junior-helper:

I see! I think I finally understand what you are talking about

Loading the data from the file using SQL*loader into a table "newtable" and then performing the select statement like
SELECT * FROM sometable WHERE somecolumn IN (SELECT number FROM newtable);
Right?

Btw. paste won't work in Oracle like DEFINE won't work on UNIX/Linux shell.

Yep (sorry if I didn't make that clearer earlier sometimes you get so used to things, you "assume" they're obvious .. )