Re: How to display full text of views

ardamon_at_srv.PacBell.COM (Tony Damon) writes:

> In article 1n1a_at_rover.ucs.ualberta.ca, chanson_at_gpu2.srv.ualberta.ca (Curtis Hanson) writes:
> >wo_at_dialog.se (Wilhelm Olander) writes:
> >
> >>>select text from user_views;
> >>>
> >>>is giving me results like this:
> >>>
> >>>select de_source.de_id, source_map.source_short, source_map.source_name
> >>> from md
>
> ..deleted
>
> >
> >>The default displaylength of LONG is not very long. Try using
> >>SQL> SET LONG 1000
> >>to get more of your source. BTW Often the ARRAYSIZE has to be redused
> >>when fetching wide records from sqlplus.
>
> ..deleted
>
> 15:43:10 CORA>set linesize 80
> 15:43:26 CORA>set long 20
> 15:43:32 CORA>select text from all_views where view_name = 'ALL_VIEWS';
>

 great for sqlplus... what about sqldba???

 set linesize 80

  gives me DBA-00110: illegal SET option

 Anyone??

--
Name : Trevor Paquette      |Alberta Energy Company  |  _\___Fahrvergnuegen
Email: TrevorPaquette_at_aec.ca|Calgary, Alberta, Canada| /     \____
Visitor from CyberSpace     |(403) 266-8400          |/ G60       \
Renegade of Virtual Reality |#include <disclaimer.h> |\-O------O--/