Hi,
I have fired SELECT * FROM TABLE; query and it returned table values in below formate:
1001 100 28,5 N 24,40
1002 200 15,9 N 20,25
I have to export above data into INSERT STATEMENT format but whenever I export data, it comes in below format:
insert into table (col1,col2,col3,col4,col5) values(1001, 100,28,5,'N',24,40); and this is wrong
It should come like this:
insert into table (col1,col2,col3,col4,col5) values(1001, 100,'28,5','N','24,40'); ---expected format
Could you help me , what can I do so that my export will come in the above format.
Thanks