10 Replies Latest reply on Sep 23, 2017 1:30 AM by 2aa021d3-1703-408c-aeab-f3edd54005a4

    Line numbers appear when copying SQL formatted text

    Manik

      Hi,

       

      I am not sure if this has been addressed already, but check this :

       

      select * from (
      select rownum r from dual
      connect by rownum<=10)
      where r<=5;
      

       

       

      As you can see the above snippet is formatted in SQL format in this thread.

      Now if I try to copy and paste it in some text editors (e.g. notepad or even notepad++ ) I always see line numbers

       

      select * from ( 

      02.select rownum r from dual 

      03.connect by rownum<=10) 

      04.where r<=5;

       

      and it becomes difficult to remove them line by line.. possible with small tricks in notepad++ to select only the line numbers and discard them, but would it not be ideal if we have  the ability to copy the code without generating line numbers?

       

      Cheers,

      Manik.