| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to display LONG column in SQL*Plus
Hi Dino,
SQL*Plus is very familiar with bind variables and PL/SQL blocks:
SQL> VAR query_text VARCHAR2(4000)
SQL> BEGIN
2 SELECT query INTO :query_text FROM dba_mviews WHERE
mview_name='X-VIEW';
3 END;
4 /
PL/SQL procedure successfully completed.
SQL> SET LONG 4000
SQL> PRINT query_text
query_text
Dino Hsu 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
Received on Tue Dec 18 2001 - 03:59:09 CST
 |
 |