RE: Create table statement

Hi Talia,

1)  Press the editor button.  It's usually the first icon in the second row.

[cid:[email protected]]

2)  If the button is greyed out, then you have to make it available by doing this...

Go to the menu - View/Toad Options... - under Windows find 'Editor' and check 'Available' and 'Auto Open' (if you want it to open automatically when you start Toad).  [Apply].

From there you can use File/Open File to locate and load your script file or paste like you mentioned.  To run it 'as a script' use F5 or press the 'Execute as Script' (lightning bolt on paper icon) button.

btw...checking out the Help (Help/Contents) might serve as a good starting point as well.



From: [email protected] [mailto:[email protected]] On Behalf Of Talia
Sent: Thursday, October 27, 2011 7:40 AM
To: [email protected]
Subject: [toad] Create table statement



Message from: TL_TL


Hello,
I'm comletely new to toad.
I want to create a table using an existing statement (I have a text file containing many "create table" statements).
I didn't find a sql editor where I can paste the existing statement...
The only way I found to create a table is to add each column and constraint one by one, using the "create table" icon on top of the tables browser.

I'm using Toad for Oracle trial version.

Any help will be greated.

TL.

_______________________________________

Historical Messages


Author: Talia
Date: Thu Oct 27 04:39:35 PDT 2011
Hello,
I'm comletely new to toad.
I want to create a table using an existing statement (I have a text file containing many "create table" statements).
I didn't find a sql editor where I can paste the existing statement...
The only way I found to create a table is to add each column and constraint one by one, using the "create table" icon on top of the tables browser.

I'm using Toad for Oracle trial version.

Any help will be greated.

TL.
__
_______________________________________