Executing a Stored Procedure snippet in Aqua Data Studio

by Nov 4, 2013

Hi,

I would like to know if it is possible to execute a Stored Procedure snippet in Aqua Data Studio without creating a Stored Procedure. I mean, running a part of the procedure without the CREATE PROCEDURE statement.

For example, can I select the below snippet and run it in Aqua Data Studio.

FOR v_row AS SELECT name FROM employee WHERE age > 50
DO
INSERT INTO …..
END FOR

If it is possible, please mention the steps involved.

Thanks in advance.

Regards,

Giri

Response

Niels Gron over 9 years ago
This depends on what database server you are working with.

With Oracle you can use an anonymous block be wrapping it with a BEGIN and END; …
psoug.org/…/anonymous_blocks.html

In SQL Server and Sybase this should work as a TSQL statement.