Home » SQL & PL/SQL » SQL & PL/SQL » SQL Loader - how to load into variable table name
SQL Loader - how to load into variable table name [message #185362] Tue, 01 August 2006 06:26 Go to next message
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 !
Re: SQL Loader - how to load into variable table name [message #185481 is a reply to message #185362] Tue, 01 August 2006 23:51 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Look at the WHEN clause in the doco.

Ross Leishman
Previous Topic: Concurrency in dynamic query using sys_context
Next Topic: Table Grants...
Goto Forum:
  


Current Time: Fri Dec 09 17:47:10 CST 2016

Total time taken to generate the page: 0.34568 seconds