Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2277
  • Last Modified:

how to execute as script in toad

I am using toad 9.7.2.5 client tool to connect to oracle 10g databse.  I do not see option like execute as script to run more than one statement at once like sqldeveloper 1.5.3(where we have separate buttons one for execute statement and other for run as script). When i try to run sequence of statements like bunch of create index etc statements only first statement getting executed and not others. Can you please tell me how can i  run/execute as script so that i can run multiple statements in one stroke. Any  navigation steps, ideas, links highly appreciated. Thanks in advance.
0
gudii9
Asked:
gudii9
  • 2
2 Solutions
 
sdstuberCommented:
load the text of your script in the sql editor,  press F5 to run the entire window's contents as a script

or click the icon of a lightningbolt over a piece of paper
0
 
ongngochoangCommented:
you can compose your script in editor then right click and choose Execute  -> Execute Script
0
 
gudii9Author Commented:
thank you very much for your help. I appreciate it.
0
 
sdstuberCommented:
glad we could help
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now