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 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 I can't > see > any way that this would work. > > Is this actually possible with SQL Loader? > > Also, she tells me that if a record exists in the table and she has > the same > record (key value only) in the input file, that SQL Loader should > update the > record with any changed field values. Is there a special keyword to > do this > - I can't seem to find anything on that either? > > Thanks in advance for any help you can give me. > > Lisa > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: YTTRI Lisa > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).