1、是“表”而不是“表格”,可以通过如下进行查询:
SELECT COUNT(*) FROM USER_TABLES;
OR
SELECT COUNT(*) FROM DBA_TABLES WHERE OWNER='USER_NAME';查存储过程:
SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE';
OR
SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER='USER_NAME' AND OBJECT_TYPE='PROCEDURE';关于2和3的问题已经有好多人提问过了,搜索一下坛子~
SELECT COUNT(*) FROM USER_TABLES;
OR
SELECT COUNT(*) FROM DBA_TABLES WHERE OWNER='USER_NAME';查存储过程:
SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE';
OR
SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER='USER_NAME' AND OBJECT_TYPE='PROCEDURE';关于2和3的问题已经有好多人提问过了,搜索一下坛子~
http://211.99.196.144:8090/forum1/frontshow/list.jsp?boardid=112
------------------------------------------------------
OTN 中文技术论坛
OCP 认证 Oracle学习资料
欢迎各路新手和高手光临!
http://211.99.196.144:8090/forum1/frontshow/index.jsp
SELECT table_name FROM USER_TABLES;
OR
SELECT table_name FROM DBA_TABLES WHERE OWNER='USER_NAME';查存储过程:
SELECT object_name FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE';
OR
SELECT object_name FROM DBA_OBJECTS WHERE OWNER='USER_NAME' AND OBJECT_TYPE='PROCEDURE';
可以看到object的名字和类型