OraFAQ Forum: SQL & PL/SQL » SQL Loader - how to load into variable table name

Home » SQL & PL/SQL » SQL & PL/SQL » SQL Loader - how to load into variable table name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader - how to load into variable table name [message #185362]

Tue, 01 August 2006 06:26

jamiecarr
Messages: 1
Registered: August 2006
Location: London UK

Junior Member

Hi,

Is it possible in SQL Loader to specify the 'INTO TABLE' name as a variable depending on the first column of data in the INFILE itself ?

e.g. if the data file contains:

M100,ABC,100.00
M200,ABC,10.00

how could I load into a table M100 for the first line, M200 for the second line etc. As I potentially have hundreds of different tables to load into, I don't want a massive load of 'WHEN' or 'IF' statements, but some substitution (&) way of doing it.
thanks !

Report message to a moderator