Home » RDBMS Server » Server Utilities » SQL LOader
SQL LOader [message #72200] Thu, 10 April 2003 05:11 Go to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,
I have 999999 in some of my data file for the date field.
I need to convert this date to oracle`s default date.

i.e.

if 999999 then i need '123149'
else
what ever specified in the field.

Thanks
~V~
Re: SQL LOader [message #72274 is a reply to message #72200] Wed, 30 April 2003 00:49 Go to previous message
yaojp
Messages: 5
Registered: April 2003
Junior Member
using decode
Previous Topic: Very Urgent Help needed - Arabic support in Forms6i& reports6i
Next Topic: table scripts
Goto Forum:
  


Current Time: Tue Dec 24 07:50:23 CST 2024