For interest, 9i introduces the SQL Loader merge command which combines
update and insert.
So if they were reading 9i doco then they might have been partly right.
Refer to Jonathan Gennick's article from Oracle Magazine - available online
at http://www.oracle.com/oramag/oracle/01-sep/index.html?
Thanks to all for reconfirming this for me. I had never heard of SQL Loader
doing these things, but couldn't quite convince the programmer.
What I have since found out is that once upon a time, a consultant came in
and set up the job that loads their data - and left without documenting it.
Lo
That's it folks. We can all go home.
Rachel says "I'm not an expert".
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, October 24, 2001 2:00 PM
To: Multiple recipients of list ORACLE-L
what documentation has your programmer been reading?
as far as I
what documentation has your programmer been reading?
as far as I know you can't add a column on the fly through a sqlloader
control file, nor will oracle do an update to existing data.
I'm not an expert, but I've never been able to do that
--- YTTRI Lisa <[EMAIL PROTECTED]> wrote:
> Hi everyo
You might ask your programmer to read the manual. However, the first might
be a nice enhancement but it's not currently available.
As for the second, SQL*Loader either inserts into an empty table or appends
to a table with existing data. It doesn't do an implicit update. However,
if your table
Lisa,
No and no. Loader loads rows into tables. If you ask nicely,
it will clean out the table completely before it does that. That's all
it does. And it does it pretty well.
It does not let users redefine tables.
And it does not do selective update and delete based on the
incoming data file. O
Monday, July 09, 2001, 11:30:20 AM, Ron Smith wrote:
SRL> We are trying to replace a VB program with SQL*Loader. Two Questions. The
SRL> input file contains record types. A type 1 header record contains data that
SRL> must be retained and combined with a type 3 record. Also, depending on the
S
Ron,
If it were me, I would use Sql*Loader to load the data into a "loading" db
tables, and then use a PL/SQL script to read that table and process the
records into wherever it is needed. You can certainly guarantee that the
data will be read in the correct order (by the PL/SQL script) by creati