Hi All,
Anyone has idea, if there is a way we can return cursor output from anonymous blocks in data grid(UI) in toad; just like we have when we execute cursors in procedure.
Thanks
Nik
Hi All,
Anyone has idea, if there is a way we can return cursor output from anonymous blocks in data grid(UI) in toad; just like we have when we execute cursors in procedure.
Thanks
Nik
Here's an example. Run the following, in the variables dialog that shows set the datatype to cursor.
begin
open :cur for select * from user_objects;
end;
On 09/18/2014 06:20 AM, Nik16 wrote:
Thread created by Nik16
Hi All,
Anyone has idea, if there is a way we can return cursor output from anonymous blocks in data grid(UI) in toad; just like we have when we execute cursors in procedure.
Thanks
Nik
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thanks for the reply Michael.
I have one query.
Also is there a way to bind variables when executing block as script?
Thanks
Nik