Re: There's gotta be a better way...

try looking oracle's documention for the create table statement...

hth,
cindy

buckwheat wrote:

> Coming fresh from an MS-SQL environment, I sure find it hard to believe
> that Ora (8.1.6 on Win2k) is so damn hard to work with. I've got to
> make a table, and give it about 50 columns. With mean Bill's tools that
> come with SQL7, I can do it in about 2 mins. Not with Oracle...
>
> Let's see, I gotta make this table. Cool. Made the tablespace, even
> setup a new schema with a cool new user that owns everything. Great.
> New table. Hot dog, I'm cookin now.
>
> Now I've got to add columns. Wait a minute, this ain't as swift as it
> was with any other data system I've used. I'll try "DBA Studio". And
> if I work at it, I can add one column a minute. This aint working.
>
> I'll try "TOAD". Same thing. No quick table-like grid interface to
> add/mod columns. How bout SQL-Navigator (Quest)? Same thing. Hell,
> can't even see columns with that thing.
>
> Now, maybe, just maybe I can use MS-Access via ODBC to really get to
> that Ora-DB. Add, modify, delete to/from the schema, wouldn't that be
> neat? No workie. Not even with Ole-DB. Hmmmm..
>
> I guess SQL-Plus is it, ain't it? "add column ... add column... add
> column... zzzz
Received on Thu May 04 2000 - 00:00:00 CDT