SQL & PL/SQL

Hi All,

I am using oracle 11g.

I am generating a csv file through the plsql  code using  UTL_FILE.

while the csv file generated  the value is coming like in excel is :

emp_id  emp_name  joining_date

1             damby  

2             damby        

Note: Joining date always

once the csv file generated, then i am uploading the csv file  in to  Target table  with data like:

emp_id  emp_no  joining date

1             damby        12/01/2018

2             damby        

Target_table:

create table target_test (emp_id varchar2(100),emp_no varchar2(100),joining_date varchar2(100));

while i am uploading the csv file , it is inserting some Julian date into joining date.

Note: in excel i can pass any string value in joining date column.

  All the columns format cell is coming as general in excel.

Expected Out put:

emp_id  emp_no  joining date

1             damby        12/01/2018

1             damby           test

Regards

Damby