Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLoader Newbie: using constant function
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