Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OBJECT DEFINITIONS - REPOST
In article <7q6vhk$5pn$1_at_nnrp1.deja.com>,
Nandakumar <N.Kumar_at_rocketmail.com> wrote:
>
>
> 1)
> i have the definitions of some objects ( table, view, procedure,
> function) in the data base. if i don't have the script that was used
to
> create these objects, is there an easy way to re-create the script
from
> the definitions available in the db.
>
> *** the following para was missing in the prev. post!
> The re-created script should have all parts that it had when it was
run
> in the database. Say, the part of the script that creates a table,
> should not only have the table structure but all the CONSTRAINTS
> associated with the table.
>
> 2) when i select a LONG field, only a part of the value is displayed
on
> screen. how could i display the whole value??
>
> Thanks!
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
--
Nandakumar
(N.Kumar_at_rocketmail.com)
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Aug 31 1999 - 10:31:56 CDT