Re: How to display LONG column in SQL*Plus

answers aren't complete:

set long 8000
set longchunksize 80
set linesize 100

longchunksize is how many chars of long to show on a line

On Tue, 18 Dec 2001 14:01:42 +0800, Dino Hsu <dino1.nospam_at_ms1.hinet.net> wrote:

>Dear all,
>
>I need to see the definition of a materialized view from dba_mviews,
>but I can't:
>
>SQL> l
> 1* select mview_name, query from dba_mviews
>SQL> /
>
>MVIEW_NAME QUERY
>--------------- ------------------------------------------------------
>MV_DMN_BASE SELECT
> rep_no,
> op_time,
> units,
> nta,
> cps,
>
>MV_FSR_BASE SELECT
> SF_MAKE_YEAR_CAMP(op_year, op_camp) op_time,
> SUBSTR(invoi
>
>
>
>SQL> desc dba_mviews
> Name Null? Type
> ----------------------------------------- -------- ---------------
> OWNER NOT NULL VARCHAR2(30)
> MVIEW_NAME NOT NULL VARCHAR2(30)
> CONTAINER_NAME NOT NULL VARCHAR2(30)
> QUERY LONG
> QUERY_LEN NUMBER(38)
> UPDATABLE VARCHAR2(1)
> UPDATE_LOG VARCHAR2(30)
> MASTER_ROLLBACK_SEG VARCHAR2(30)
> MASTER_LINK VARCHAR2(128)
> REWRITE_ENABLED VARCHAR2(1)
> REWRITE_CAPABILITY VARCHAR2(9)
> REFRESH_MODE VARCHAR2(6)
> REFRESH_METHOD VARCHAR2(8)
> BUILD_MODE VARCHAR2(9)
> FAST_REFRESHABLE VARCHAR2(18)
> LAST_REFRESH_TYPE VARCHAR2(8)
> LAST_REFRESH_DATE VARCHAR2(9)
> STALENESS VARCHAR2(9)
> AFTER_FAST_REFRESH VARCHAR2(9)
> COMPILE_STATE VARCHAR2(13)
>
>
>The column 'query' is of type LONG, anyone knows how to display a LONG
>column in SQL*Plus? I hope this is not too basic, but I have tried for
>a long time. The version is SQL*Plus 8.1.7, thanks in advance.
>
>Dino
>OCP DBA, Taipei
>

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email