Database query

Applications Programming
1

I am getting an error function in date formate while importing the date ccolumn in oracle sql developer tool

My date format in table is 6-Nov-14 and while importing its converted to 6/11/14 eventhough the format is as 6-Nov-14 in excel.

could you please let help me out what I need to change in the date column format to pick it as this format 6-Nov-14.

2

SQL developper tool is specific and has nothing to do with shel, thread moved to programming

3

While importing data(In column definition step), you have to set date format

4

I have set the date format, But I am getting the current date instead the date present in the excel is not getting updated for all the column.

not sure what needs to be changed.

5

It would help to hear what error message you get.
Is the column you import the date-value into defined as date or as varchar2?
In case it is defined as date it is stored in an internal format and just presented differently when you query it. The representation is defined by the NLS-settings of the client-machine you use to query the table:

$ export NLS_DATE_FORMAT='DD/MM/RR'
$ sqlplus -s / <<<"select sysdate from dual;"

SYSDATE
--------
19/11/14

$ export NLS_DATE_FORMAT='DD-MON-RR'
$ sqlplus -s / <<<"select sysdate from dual;"

SYSDATE
------------------
19-NOV-14
6

thanks.

I have around 50,000 records to be updated in my oracle table.

whether I can import thru sql developer tool.

7

You've asked the question about using SQL Developer in your other thread and I've responded to it over there already.

In brief, the answer is - yes, you can insert data from an Excel spreadsheet to an Oracle table using SQL Developer.