SQL Loader for multiple tables?

From: Gary G <tolimits_at_pil.net>
Date: 1998/02/04
Message-ID: <6b9seg$jv0@netaxs.com>#1/1

Hi,
I'm facing a situation where I have data coming to me in two possible ways: 1) Each table in separate file, coma delimited, enclosed in quotes 2) All tables in one file, coma delimited, enclosed in quotes, separated by "INSERT INTO" or some other clause....

What would be a best approach to load above into into DB? I can't seem to figure out the syntax for above, or wether its possible at all.....sure hope it is. I can't imagine that there is no better way of doing rather one table at a time.

About 300 tables
Oracle 7.3.3/NT 4
Thanks,
Gary Gorbonosov
tolimits_at_pil.net
/* Comment your code & nobody gets hurt */ Received on Wed Feb 04 1998 - 00:00:00 CST