Re: How to display LONG column in SQL*Plus

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 18 Dec 2001 19:28:36 +1100
Message-ID: <3c1efdc3$0$25278$afc38c87@news.optusnet.com.au>

Just as you can

set pagesize 2000
set linesize 132

and so on in SQL Plus, so you can

set long 4000
(or some other suitable value)

Then these things should display more fully.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message
news:t5lt1ughs1blqbt8kjgq9ncoq76t4jt8gm_at_4ax.com...


> 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

>

Received on Tue Dec 18 2001 - 02:28:36 CST