4 Replies Latest reply on Apr 30, 2019 3:57 PM by EdStevens

    Running worksheet queries without highlighting them (?)

    AnnieM

      Greetings,

       

      I am using Version 4.2.0.17.089 of SQL Developer.

      Oracle version is: 10.1.0.5.0

       

      Why do I need to select/highlight the queries I want to run in SQL Developer?

       

      Is there a way to configure so pressing 'Run" would execute all queries on the SQL worksheet?

       

      For instance if I select "run" with this on the screen, nothing happens:

       

      I need to select all lines, e.g.:

       

      I googled for a solution but could not find. Perhaps I am wording it incorrectly.

       

       

      Thank you so much for your help!

      Annie

        • 1. Re: Running worksheet queries without highlighting them (?)
          thatJeffSmith-Oracle

          you don't need to, not for your example

           

          for your example, but your cursor anywhere INSIDE that select statement, and hit ctrl+enter or F9

           

          your bigger problem is that your DB is ancient and even your copy of SQL Developer is about 2 years old

          • 2. Re: Running worksheet queries without highlighting them (?)
            Gaz in Oz

            CTRL-A will highlight all text in worksheet, then hit "Run".

            If you want to run multiple queries at the same time then you will obviously want to tick the " [ ] show query results in new tabs" box under

            Tools -> Preferences -> Database -> Worksheet,

            otherwise only the last queries results will be visible in the single query results tab.

            Hitting "Run Script" does execute everything in the worksheet without you having to move the cursor or highlight anything.

            1 person found this helpful
            • 3. Re: Running worksheet queries without highlighting them (?)
              AnnieM

              Thank you Gaz in Oz and Jeff!

               

              I appreciate your time and help.


              All the best to you, Annie

              • 4. Re: Running worksheet queries without highlighting them (?)
                EdStevens

                AnnieM wrote:

                 

                Greetings,

                 

                I am using Version 4.2.0.17.089 of SQL Developer.

                Oracle version is: 10.1.0.5.0

                 

                Why do I need to select/highlight the queries I want to run in SQL Developer?

                 

                Is there a way to configure so pressing 'Run" would execute all queries on the SQL worksheet?

                 

                For instance if I select "run" with this on the screen, nothing happens:

                 

                I need to select all lines, e.g.:

                 

                I googled for a solution but could not find. Perhaps I am wording it incorrectly.

                 

                 

                Thank you so much for your help!

                Annie

                The first two icons in tye worksheet toolbar are 'Run Statement (Control-Enter)' and 'Run Script (F5)'

                If you want to run a single statement, just place your cursor in that statement (don't actually select any of it) and hit the appropriate icon or key sequence.

                If you want to run all of the statements in the worksheet, just hit the appropriate icon or key.

                1 person found this helpful