Oracle SQL Developer exporting SQL inserts with missing comma.
From: Hans Deragon <hans_at_deragon.biz>
Date: Sun, 14 Dec 2008 16:50:41 -0500
Message-id: <49457FB1.8040104@deragon.biz>
--
http://www.freelists.org/webpage/oracle-l Received on Sun Dec 14 2008 - 15:50:41 CST
Date: Sun, 14 Dec 2008 16:50:41 -0500
Message-id: <49457FB1.8040104@deragon.biz>
Greetings.
Sorry for this basic question, but with Oracle SQL developer latest version (1.5.3), when I export a table using the "insert" mode, the output looks something like this:
insert into table1 values (123 456 769);
The commas are missing. It should be:
insert into table1 values (123, 456, 769);
Searched the web, looked at the preferences, but could not find anything that would help me properly configure Oracle SQL developer. Anybody has a clue?
Best regards,
Hans Deragon, B. ing.
--
Consultant en informatique/Software Consultant
Deragon Informatique inc.
http://www.deragon.biz Open source (contribution): mailto://hans@deragon.biz http://autopoweroff.sourceforge.net
--
http://www.freelists.org/webpage/oracle-l Received on Sun Dec 14 2008 - 15:50:41 CST