Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: SQL Loader Concatenate date and time

Re[2]: SQL Loader Concatenate date and time

From: Jonathan Gennick <>
Date: Fri, 30 May 2003 07:15:20 -0800
Message-ID: <>

Thursday, May 29, 2003, 6:00:49 PM, Bob wrote: BM> Thanks for answering my question. I diddnt realise you could BM> querry colums ahead of the current line.

As I recall, it took me a long time to realize that too. It may help to realize that everything you type between double-quotes (those SQL expressions) are made part of the INSERT statement SQL*Loader uses to insert each row. By the time that INSERT gets executed, SQL*Loader has to have parsed the input record and isolated all the fields. Thus, in a SQL expression, you have access to all the fields all the time.

Related to the above, before Oracle9i, using SQL expressions with SQL*Loader precludes doing a direct-path load. 9i relaxed that restriction somewhat. It's been awhile though, since I've looked at exactly what 9i allows.

You can see your SQL expressions in the INSERT statement. Just enable SQL tracing while you run one of your loads.

Best regards,

Jonathan Gennick --- Brighten the corner where you are * 906.387.1698 *

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit, or send email to and include the word "subscribe" in either the subject or body.


Please see the official ORACLE-L FAQ:

Author: Jonathan Gennick

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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). Received on Fri May 30 2003 - 10:15:20 CDT

Original text of this message