Re: How to Generate Create Script?

On Thu, 14 Oct 1999 14:40:01 GMT, cnwy_at_my-deja.com wrote:

I have C source code to do this for most oracle objects. You can probably convert it to pl/sql and use utl_File or text_io, or just capture it in sql*plus using dbms_output if you can't compile the c code. email me if you need it: givler.eric_at_dep.state.pa.us

>I want to generate the related script of a table;
>for example.
>Create table t1
>(f1 char(10),
> f2 number(10),
> primary key(f1));
>
>create index t1_idx on t1(f1);
>...
>
>and I want to use User_triggers,User_indexes,User_constraints
>to generate the above code of table 't1'.
>can any one give some help?
>
>Any suggestions are helpful!
>Thanks in advance!
>
>YangWang.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 15 1999 - 19:07:46 CDT