OraFAQ Forum: Client Tools

Home » Other » Client Tools » Toad

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Toad [message #275570]

Sun, 21 October 2007 22:10

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.

Report message to a moderator

Re: Toad [message #275626 is a reply to message #275570]

Mon, 22 October 2007 02:03

Frank
Messages: 7901
Registered: March 2000

Senior Member

Press F1

Report message to a moderator

Re: Toad [message #275651 is a reply to message #275570]

Mon, 22 October 2007 03:45

Littlefoot
Messages: 21823
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;

Report message to a moderator

Re: Toad [message #276478 is a reply to message #275626]

Thu, 25 October 2007 04:51

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

Report message to a moderator

Re: Toad [message #276525 is a reply to message #276478]

Thu, 25 October 2007 07:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

... but, (probably) depending on TOAD version, F9 or <Shift - F9> might do the job.

Report message to a moderator

Re: Toad [message #276688 is a reply to message #276478]

Fri, 26 October 2007 00:25

Frank
Messages: 7901
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?

Report message to a moderator

Re: Toad [message #276707 is a reply to message #276688]

Fri, 26 October 2007 01:10

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.

Report message to a moderator

Re: Toad [message #276709 is a reply to message #276707]

Fri, 26 October 2007 01:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Toad [message #276710 is a reply to message #276709]

Fri, 26 October 2007 01:16

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

Report message to a moderator

Re: Toad [message #276717 is a reply to message #276707]

Fri, 26 October 2007 01:45

Frank
Messages: 7901
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.

Report message to a moderator

Previous Topic:	Oracle Queries
Next Topic:	Problem with format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:04:04 CST 2025