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.