Oracle DBA 常用SQL 语句
-
编辑 删除
查看数据库字符集
SQL> SELECT NAME,VALUE$ FROM SYS.PROPS$ WHERE NAME='NLS_CHARACTERSET';NAME------------------------------VALUE$--------------------------------------------------------------------------------NL...
-
编辑 删除
DBA 常用SQL
1. 如何查找数据对象 如package select object_name, OWNER from all_objects where object_name like '%GSB%' and object_type='PACKAGE';SQL> select distinct object_type from all_objects;OBJEC...
