如题!!!!
解决方案 »
- 一个表,exp不出错,expdp出错,IO错误!!!!
- ORACLE 10导出 表和存储过程问题
- oracle 存储过程类型对应问题
- 怎样删除Oracle数据库中的序列化?
- 請教一個關于exception的問題
- 请教各位: 如何解决在unix下使用sql loader将数据导入oracle后,导入数据在数据库中乱码的问题?
- 请教:pl/sql问题
- 请问哪里有oracle9i书籍下载?
- 求SQL语句!!!!!!!急呀!!!!
- Toad for oracle 12.8 中文版 连接数远程 Oracle 据库提示 无法初始化 OCI。错误-1
- oracle如何读未提交的数据
- 连接oracle数据库时出现sqlsetconnectAttr失败
2 (
3 ID NUMBER not null,
4 IP VARCHAR2(20),
5 NAME VARCHAR2(10),
6 EMAIL VARCHAR2(40),
7 QQ VARCHAR2(10),
8 POSTTIME DATE
9 )
10 /Table createdSQL>
SQL> create or replace view bookview as
2 select *
3 from book
4 /View createdSQL>
SQL> SELECT REFERENCED_NAME, REFERENCED_TYPE
2 FROM SYS.ALL_DEPENDENCIES
3 WHERE TYPE = 'VIEW'
4 AND NAME = UPPER('bookview')
5 AND REFERENCED_TYPE = 'TABLE'
6 /REFERENCED_NAME REFERENCED_TYPE
---------------------------------------------------------------- -----------------
BOOK TABLESQL>
FROM ALL_DEPENDENCIES
WHERE TYPE = 'VIEW'
AND OWNER='&OWNER'
AND NAME = '&NAME'
AND REFERENCED_TYPE = 'TABLE'
/
COL REFERENCED_NAME FORMAT A15
SELECT REFERENCED_OWNER,REFERENCED_NAME,REFERENCED_TYPE
FROM ALL_DEPENDENCIES
WHERE TYPE = 'VIEW'
AND OWNER='&OWNER'
AND NAME = '&NAME'
AND REFERENCED_TYPE = 'TABLE'
/