how to execute as script in toad

Posted on 2009-02-19
Last Modified: 2013-12-18
I am using toad 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.
Question by:gudii9
    LVL 73

    Accepted Solution

    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
    LVL 3

    Assisted Solution

    you can compose your script in editor then right click and choose Execute  -> Execute Script
    LVL 7

    Author Closing Comment

    thank you very much for your help. I appreciate it.
    LVL 73

    Expert Comment

    glad we could help

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now