摘要:
SELECT Column_Name, DATA_TYPE from cols t1 LEFT JOIN user_objects ON t1.table_name = user_objects.OBJECT_NAMEwhere user_objects.OBJECT_TYPE='VIEW' AND 阅读全文
摘要:
1 查询 查询所有表空间 select * from sys.dba_tablespaces; 查询当前用户的所有目录 select * from dba_directories; 查询所有用户 select * from dba_users; 删除 删除用户 drop user jxythtest 阅读全文