Re: OBJECT DEFINITIONS!

1. Try user_source. Sometimes you can get it easily from views like user_views etc.
2. set long 8000, set pagesize 0, set trimspool on, set linesize 1000, then do the select.

Martin

Nandakumar 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.
>
> 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.
Received on Sun Sep 05 1999 - 07:17:05 CDT