How to display LONG column in SQL*Plus

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Tue, 18 Dec 2001 14:01:42 +0800
Message-ID: <t5lt1ughs1blqbt8kjgq9ncoq76t4jt8gm@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 - 00:01:42 CST