It depends on how you wrote the sql. The sql needs to have no carriage
returns between two sql lines. That is:
SELECT
* FROM DUAL
will not work.
SELECT
* FROM DUAL
will work fine.
If you have only one script you can place the cursor anywhere inside the
script and press Ctrl + Enter, and it will automatically run the script
you placed the cursor in. You can also run it by pressing the running
man icon.
If you have multiple sql scripts and you want to run them all at once,
each script must end in semicolon, and you have to select all the
scripts and then run.
Each script you run will open inside a tab in the lower part. Each tab
has a running man icon in the rightmost part of the tab. That will rerun
the script. For example if you uncheck the limit rows and want to rerun
it, or change the no. of limited rows, or you changed anything that
would change the output of the same script.
On 10/30/2014 6:31 PM, abandaru wrote:
> you may try option Ctrl+Shift+S, available in Version 3.6. to select current
> SQL.
>
> 1) Ctrl+Shift+S to select current SQL
> 2) Ctrl+Enter to run.
>
>
>
>
>
>
>
> --
> View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/How-to-Run-Whole-Script-at-Once-tp3387p3471.html
> Sent from the Users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|