Hi All,
My flat file lets say has the following contents
HTML Code:
AT & T
CITIZENS MOHAVE CELLULAR
COMMNET
DRR
E1CELLULAR
....
Now, Im trying to select data from a flat file(sitting on unix server) and want to run a simple query as below(running Oracle 10g)
HTML Code:
SELECT MO_IDENTIFER, SERVICE_PROVIDER FROM MVNO_SP WHERE SERVICE_PROVIDER IN (....
FLAT FILE CONTENTS.
);
I only have READ privileges on this db & hence external tables are not option. So, how do I do a look up on this file & then run a select based on the value of the MVNO Operator generated from the above file. In other words, how do I construct a sql statement where in the value of each row is passed to a variable and that variable is used to read data from the db as below
HTML Code:
SELECT MO_IDENTIFER, SERVICE_PROVIDER FROM MVNO_SP WHERE SERVICE_PROVIDER IN (
'AT & T',
'CITIZENS MOHAVE CELLULAR',
'COMMNET'
.....
);
I been staring at various postings on this topic for a while now and so far, not thing has been posed on the lines of what Im talking about here as everyone has chosen the option of external tables where in we specify the directory that it has to be read from, define the file format etc etc..
Please help.
regards,
PGonzalez.