Re: How to display LONG column in SQL*Plus

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

Yes, regrettably it is basic, and once more it demonstrates (not directed at you) the relative merit of the OCP exam. Just issue
set long <any high number> in sql*plus before running the query, and that's all

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Dec 18 2001 - 07:24:55 CST