Re: Printing SQLPlus Code

From: Radu Lascae <r.nospam.lascae_at_wanadoo.nl>
Date: Sat, 10 Nov 2001 08:27:00 GMT
Message-ID: <ox5H7.31$sw2.457@pollux.casema.net>

You can't do this, as the same table may be created using different scripts, e.q. by specifying primary keys in the CREATE TABLE statement or after the statement, with an ALTER TABLE. No way to guess exactly how, afterwards.

You can create a script that would recreate the same object though, using the data dictionary tables (for example user_tab_columns). A freeware tool that will do this for you is TOAD, download from www.toadsoft.com.

Hth,
Radu

"Jayne Heger" <jayne.heger_at_ntlworld.com> wrote in message news:nqfhs9.f1o.ln_at_bealzebub.ntlworld.com...
> Hi All,
>
> I am a newbie, so please excuse me!
>
> I am using Oracle for one of my assignments at university. Anyway, I have
> created my tables, but I didn't specify the 'spool' command before I
> created them, and I really need to be able to print out the SQLCode for
> creating them.
> I can't find anything on the web which says you can print out the code
> after, unless I'm missing something.
>
> Sorry if this is a really easy question thats been asked 1 million
times.;)
>
> Thanks
>
> Jayne
>
Received on Sat Nov 10 2001 - 02:27:00 CST