OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sqlldr

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr [message #74764]

Mon, 14 February 2005 01:28

koppargaon
Messages: 2
Registered: January 2005

Junior Member

I wish to convert a foxbase file into oracle through sqlldr.
I create a txt file as copy to test.txt delimited with #.
I have checked in txt file date in foxbase is converted as yyyymmdd.
In control file I have given against field date as
fieldname date 'yyyymmdd'
It converts into oracle table as dd-mon-yy. I wish to get it as dd-mon-yyyy. Can you suggest a solution.
Regards,
Malhotra

Report message to a moderator

Re: sqlldr [message #74765 is a reply to message #74764]

Mon, 14 February 2005 01:34

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

DD-MON-YY is just the default display format. You can set the display format to whatever you fancy. Here is an example:

SQL> SELECT sysdate FROM dual;

SYSDATE
---------
14-FEB-05

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';

Session altered.

SQL> SELECT sysdate FROM dual;

SYSDATE
-----------
14-FEB-2005

Best regards.

Frank

Report message to a moderator

Previous Topic:	Facing Problem during Importing Data using IMP.
Next Topic:	oracle installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:44:38 CDT 2024