Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer autoformating text values with hypen (-)

GeorgeyJul 7 2011 — edited Oct 27 2011
Hi
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2011
Added on Jul 7 2011
5 comments
944 views