Re: SQL*LOADER

From: Rohrbacher, Boris <rohbo_at_sbox.tu-graz.ac.at>
Date: Fri, 26 Jun 1998 21:07:21 +0200
Message-ID: <3593F169.8CF107BC@sbox.tu-graz.ac.at>

javier mugueta_unzué wrote:

> Hi everybody!
> When loading data with the loader I want to put in a column of the tabl=
e
> a constant value than is not in the flat file. How can I do that?

a.) reading SQL loader manual. see specifing columns

b.) if you don't like a.

( column_1 .... ,

.... ,
column_x CONSTANT 'THE VALUE' ,

)

Also possible : RECNUM for record number loading , SYSDATE, SEQUENCE

Regards Robo

Received on Fri Jun 26 1998 - 14:07:21 CDT