Home » SQL & PL/SQL » Client Tools » using TOAD where i will write cursor program and where i will run?
using TOAD where i will write cursor program and where i will run? [message #222972] Wed, 07 March 2007 01:35 Go to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

using TOAD where i will write cursor program and where i will run?
Re: using TOAD where i will write cursor program and where i will run? [message #222973 is a reply to message #222972] Wed, 07 March 2007 01:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Press F1
Re: using TOAD where i will write cursor program and where i will run? [message #223153 is a reply to message #222973] Wed, 07 March 2007 14:56 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, do not press F1. It will start this year's Formula 1 car racing season too early - it is scheduled for March 18th in Melbourne, Australia (that's down under, where people stand on their heads). So - wait a little bit longer.

Write your cursor programs in SQL (or even Procedure) Editor. It will be either an anonymous PL/SQL block (so run it by clicking on "Execute as script" button) or perhaps a named procedure (so you'd run it by typing "EXEC procedure_name" and pressing the same "Execute as script" button again.

There might be different issues about the whole thing (for example, passing parameters, using functions instead of procedures etc.), but - you'll tell us when you come to it.
Re: using TOAD where i will write cursor program and where i will run? [message #223230 is a reply to message #223153] Thu, 08 March 2007 01:42 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Seeing his vast batch of very basic questions the OP poured out over us at the time he posted this, I thought it wise to point out to him that there is a thing called 'Help'.
Re: using TOAD where i will write cursor program and where i will run? [message #223243 is a reply to message #223230] Thu, 08 March 2007 02:37 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I know; I was just kidding.
Re: using TOAD where i will write cursor program and where i will run? [message #223248 is a reply to message #222972] Thu, 08 March 2007 03:08 Go to previous message
subramanian.sp
Messages: 13
Registered: March 2007
Location: Pune
Junior Member
open a new procedure edit window and write your procedures/functions/package and press f9.
The procedures will get compile.
Previous Topic: I am trying to compile sequence in SQL Editor(using TOAD) but not compile in TOAD?
Next Topic: sql developer for debugging
Goto Forum:
  


Current Time: Fri Dec 02 23:19:08 CST 2016

Total time taken to generate the page: 0.09502 seconds