Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
D:\Documents and Settings\Administrator>
D:\Documents and Settings\Administrator>
D:\Documents and Settings\Administrator>
D:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 4月 14 13:23:05 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/kennethlee@orcl9201 as sysdba
已连接。
SQL>
SQL>
SQL>
SQL> desc dba_views
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
SQL> select owner, view_name, text
2 from dba_views
3 where lower(owner) = 'hr';
from dba_views
*
ERROR 位于第 2 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-01406: 读取的列值被截断
SQL>
SQL>
SQL> select owner, view_name, text
2 from dba_views
3 where lower(view_name) = 'dept50';
from dba_views
*
ERROR 位于第 2 行:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-01406: 读取的列值被截断
SQL>
*************************************************************
SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 4月 14 13:30:25 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> show user
USER 为"HR"
SQL>
SQL>
SQL> desc user_views
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
SQL>
SQL> select view_name, text
2 from user_views
3 ;
VIEW_NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
DEPT50
select e.employee_id, e.last_name, e.department_id
from employees e
where e.
EMPLOYEES_VU
select employee_id, first_name Name, department_id
from employees
VIEW_NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
EMP_DETAILS_VIEW
SELECT
e.employee_id,
e.job_id,
e.manager_id,
e.department_id,
d.locat
SQL>
这是怎麽回事啊?
另外:
VIEW_NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
DEPT50
select e.employee_id, e.last_name, e.department_id
from employees e
where e.
和
VIEW_NAME
------------------------------
TEXT
--------------------------------------------------------------------------------
EMP_DETAILS_VIEW
SELECT
e.employee_id,
e.job_id,
e.manager_id,
e.department_id,
d.locat
中的TEXT都看不全,怎麽才能看到完整的text呢?