8 Replies Latest reply: Aug 23, 2013 11:18 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Developer minor issues

    Gamblesk

      Couple of Sql Developer quality of life things.

       

       

      1) Reports Autorefresh steals focus.

       

         There are times I would like to have a report refreshing occasionally on my second

         monitor this is impossible with SQL Developer stealing the focus when the report refreshes.

       

      2) Mouse scroll wheel does not seem to work anywhere that there is a drop down list of connections.

       

      3) When running a report as a script the output appears to be run through the same formatter that the

           editor uses. Don't think this is needed.

            

      4) reports of type script seem to be padded with spaces.

       

         I have a select statement in a child report (type script) that generates sql commands that I can then

         cut and paste into SQL*Plus  to run. Those commands get padded with spaces on the right to such

         a length that they exceed the length that SQL*Plus can handle on one line. Below is one example

         but I have others some are shorter than others and they cut and paste fine. I am not sure what decides

         the padding on the report.

       

         I run this select as the query in the child.

       

             select 'var output_number number;

             BEGIN

             :output_number:=DBMS_SPM.ALTER_SQL_PLAN_BASELINE (

             sql_handle=>'''||:SQL_HANDLE||''',

             plan_name=>'''||:PLAN_NAME||''',

             attribute_name =>''FIXED'',

             attribute_value =>''YES'');

             END;

             /

             print :output_number;' Command from dual;

       

         Which produces this output when executed. Not sure if it will come    through the forums but each

         line is padded out to ~265 characters after being cut and paste from SQL*Developer. My version

         of SQL*Plus seems to have a 258 character limit for one line. I left the below exactly the

         way the paste happened. It should look more like the above.

       

          var output_number number;                                                                                                                                                                                                                                        

       

          BEGIN                                                                                                                                                                                                                                                            

            :output_number:=DBMS_SPM.ALTER_SQL_PLAN_BASELINE (                                                                                                                                                                                                                       

            sql_handle=>'SQL_1f0b9fc467db48b3',                                                                                                                                                                                                                              

            plan_name=>'SYS_OUTLINE_130724085620759',                                                                                                                                                                                                                        

            attribute_name =>'FIXED',                                                                                                                                                                                                                                        

            attribute_value =>'YES');                                                                                                                                                                                                                                        

          END;                                                                                                                                                                                                                                                             

          /                                                                                                                                                                                                                                                                

          print :output_number;                                                                                                                                                                                                                                            

       

         The first line 'var output_number number' is the only thing displayed (across 2 lines )

         and my cursor gets stuck until I CTRL-C. Like I mentioned above this seems to be a

         SQL*Plus issue on my platform but I still think developer should not pad with that

         man spaces.

       

         If I paste it into notepad first and trim all the spaces from the end I am able to then

         copy from notepad and paste into SQL*Plus.