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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to disable the line numbering for F5 when echo is on

mNemDec 3 2017 — edited Dec 7 2017

I have just switched over to sql developer 17.3.1 from 4.1.5.

If I set the echo on and and press F5 to run a sql statement, in the output, it adds the line numbers by default. This wasn't the case in 4.1.5.

Now and then, when I get a chance to answer a question on OTN SQL space, it was handy to just copy paste the entire contents of the output window which had both the sql statement and the result set. Later, if the OP or anyone wants to copy paste the sql and test it on their end, they need to remove those line numbers first before running it which is additional work.

How can I disable the line numbering from the output?

sqldev.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2018
Added on Dec 3 2017
7 comments
866 views