Re: SQLLoader Newbie: using constant function

From: Alan Moor <asmoor_at_ix.netcom.com>
Date: Thu, 12 Aug 1999 07:09:04 -0400
Message-ID: <7ouaqn$5iu@dfw-ixnews6.ix.netcom.com>

Use
Constant '0'

SQL Loader takes all constants (and WHEN clauses, for that matter) as strings and converts them to the appropriate data type.

oliver wrote in message <37B1AC6F.C2A6A51A_at_agyinc.com>...
>Hi,
>
>I am try to insert a constant number (0) into one column of the table
>when I use SQLLOADER to loader data into a table. Can anyone give me a
>clue what should I, or an sample code.
>
>The explanation of CONSTANT function in Oracle online documentation is
>very confuse. I can not find the sample of using this function. What
>is the proper place to check out?
>
>Thanks for your reply
>
>--
>Oliver
>
Received on Thu Aug 12 1999 - 06:09:04 CDT