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
: rootcc:
Subject: SQL Loader questions
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
Hi everyone -
I need some help. We have an application running on 8.0.5 on NT. My
programmer tells me that she should be able to add columns to a table simply
by changing the sql loader control file definition of the input. I have
looked through the documentation and tried several tests, but
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
We are trying to replace a VB program with SQL*Loader. Two Questions. The
input file contains record types. A type 1 header record contains data that
must be retained and combined with a type 3 record. Also, depending on the
record type the data is loaded into different tables. Is all this po
10 matches
Mail list logo