Home » SQL & PL/SQL » Client Tools » Toad
Toad [message #275570] Sun, 21 October 2007 22:10 Go to next message
msafana
Messages: 31
Registered: July 2007
Member
hi all,
Iam new to toad environment,just i want to know that,
If we wrote the function or procedure in toad,we can write it in procedure editor,where we need to write anonymous block to call those procedures and functions,and how to execute it.

Thank u.
Re: Toad [message #275626 is a reply to message #275570] Mon, 22 October 2007 02:03 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Press F1
Re: Toad [message #275651 is a reply to message #275570] Mon, 22 October 2007 03:45 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'd use SQL Editor.

Call them as you'd do it in SQL*Plus. For example:
-- call a procedure; press "execute as a script" button
exec procedure_name;

-- call a function
SELECT function_name FROM dual;
icon12.gif  Re: Toad [message #276478 is a reply to message #275626] Thu, 25 October 2007 04:51 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Frank wrote on Mon, 22 October 2007 09:03

Press F1


Actually that won't work, that won't execute the function/procedure
Re: Toad [message #276525 is a reply to message #276478] Thu, 25 October 2007 07:11 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
... but, (probably) depending on TOAD version, F9 or <Shift - F9> might do the job.
Re: Toad [message #276688 is a reply to message #276478] Fri, 26 October 2007 00:25 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
MarcS wrote on Thu, 25 October 2007 11:51

Frank wrote on Mon, 22 October 2007 09:03

Press F1


Actually that won't work, that won't execute the function/procedure

And what DOES it do?
Re: Toad [message #276707 is a reply to message #276688] Fri, 26 October 2007 01:10 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Frank wrote on Fri, 26 October 2007 07:25

MarcS wrote on Thu, 25 October 2007 11:51

Frank wrote on Mon, 22 October 2007 09:03

Press F1


Actually that won't work, that won't execute the function/procedure

And what DOES it do?


If you really want to know the answer to your question, please open a new thread Wink

Seriously: I know that lots and lots of questions are asked repeatedly, and that with a bit of effort can easily be found somewhere on the net or in helpfiles.

But that doesn't give the experienced ones - like you and and a few others (maybe me included) - not the right to just bluntly respond with "PRESS F1" or something along that line and in the meantime thinking not so nice thoughts about the poster Wink

In my experience a far more better approach is to just answer the question at hand AND then politely (!) point out that there are helpfiles, or other thread with the same question.





Re: Toad [message #276709 is a reply to message #276707] Fri, 26 October 2007 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

In my experience a far more better approach is to just answer the question at hand AND then politely (!) point out that there are helpfiles, or other thread with the same question.


In my experience if you give the answer, poster don't read further.

Regards
Michel
Re: Toad [message #276710 is a reply to message #276709] Fri, 26 October 2007 01:16 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Michel Cadot wrote on Fri, 26 October 2007 08:14

Quote:

In my experience a far more better approach is to just answer the question at hand AND then politely (!) point out that there are helpfiles, or other thread with the same question.


In my experience if you give the answer, poster don't read further.

Regards
Michel



I'm not surprised; the way you sometimes answer questions Wink
Re: Toad [message #276717 is a reply to message #276707] Fri, 26 October 2007 01:45 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
MarcS wrote on Fri, 26 October 2007 08:10

In my experience a far more better approach is to just answer the question at hand AND then politely (!) point out that there are helpfiles, or other thread with the same question.


I think it depends on the type of question.
The original poster went to Quest's site to download TOAD, started it up, read NOTHING about how to use TOAD and then comes to this site to ask how to use it.
That's where I draw the line for me. I think this forum is not intended to be a help-forum for TOAD-newbies, Quest has more than enough resources for that.
This forum (in my opinion) is meant for Oracle problems related to the use of certain tools.
Previous Topic: Oracle Queries
Next Topic: Problem with format
Goto Forum:
  


Current Time: Sun Dec 04 06:20:41 CST 2016

Total time taken to generate the page: 0.08786 seconds