Home » SQL & PL/SQL » Client Tools » Question Regarding Line Numbering For SQL Developer (Oracle 11g R2)
Question Regarding Line Numbering For SQL Developer [message #594472] Wed, 28 August 2013 22:37 Go to next message
Robs58
Messages: 15
Registered: May 2013
Junior Member
I have a question regarding SQL Developer. When opening a SQL Developer worksheet, there are two different panes or work areas; the upper pane contains the query code and the bottom pane contains the query results (output). Using the
Tools===Preferences tab, I was able to enable line numbering for the top pane (code) but I haven't figured out how to enable line numbering for the bottom pane (results area). Does anybody know how to enable line numbering for the bottom pane? Thanks!

Robs58
Re: Question Regarding Line Numbering For SQL Developer [message #594482 is a reply to message #594472] Thu, 29 August 2013 01:58 Go to previous messageGo to next message
Littlefoot
Messages: 19610
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which SQL Developer version do you use? Mine (3.1.07) shows line numbers in the results (bottom) pane (I don't use SQL Developer regularly, but I can't remember I set it manually - I believe it works so by default).

Re: Question Regarding Line Numbering For SQL Developer [message #594489 is a reply to message #594482] Thu, 29 August 2013 02:49 Go to previous messageGo to next message
pablolee
Messages: 2617
Registered: May 2007
Location: Scotland
Senior Member
If you're outputting a statement, you get a table with row numbers. If you're outputting a script, you don't get row numbers unless you choose to code them in.
Re: Question Regarding Line Numbering For SQL Developer [message #595842 is a reply to message #594489] Sat, 14 September 2013 09:46 Go to previous message
Robs58
Messages: 15
Registered: May 2013
Junior Member
Thanks to all who posted!

Pabolee - special thanks to you. I verified what you said and it showed me what I needed to see. Thanks!

Regards,

RobS
Previous Topic: No Semi-colon used in buffer editor Sqlplus
Next Topic: Date result different for same query in Toad and SQL Developer
Goto Forum:
  


Current Time: Thu Sep 18 16:46:47 CDT 2014

Total time taken to generate the page: 0.13863 seconds