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~

Report message to a moderator

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

Report message to a moderator

Previous Topic: Very Urgent Help needed - Arabic support in Forms6i& reports6i
Next Topic: table scripts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 18 06:31:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.