SQL Developer autoformating text values with hypen (-)
GeorgeyJul 7 2011 — edited Oct 27 2011Hi
This happens in SQL Developer. The version which I use is 2.1.0.63
When I insert a varchar2 value to a column in the table, if there is a hyphen in the text and if there are empty lines in the text, the empty lines are lost. If there is no hyphen, it works fine.
Below is an eg:
Create table test (error Varchar2(500));
Insert into test values ('This
is
a
test
-
');
Select * from test;
The result copied to a notepad is below
--------------------------------
This
is
a
test
-
Now remove the hypen from the text and insert the record
The result copied to a notepad is below
------------
This
is
a
test
Can anyone explain me why this is happening. I have a lot of text with hyphen and almost all my records are auto-formatted by sql developer.
any help is appreciated.
Warm Regards
-Georgey
Edited by: 859895 on Jul 7, 2011 4:14 PM