oracle的一点点小笔记
1===============================修改sys密码的方法
用ora_dba组的用户进系统，在ＤＯＳ命令下
sqlplus /nolog
sql> connect / as sysdba;
sql>alter user sys identified by sdfasd_1;
2==========================================
====如何在数据字典中利用Oracle 语句查找出已经建立的存储过程，存储函数和触发器和包
Select object_name From user_objects Where object_type=’PROCEDURE’
Select object_name From user_objects Where object_type=’FUNCTION’
Select object_name,status From user_objects Where object_type=’TRIGGER’
Select object_name,object_type,status From user_objects Where object_type like 'PACKAGE%'
还可以查看包的具体内容
Select text FRom user_source Where name='EMP_PK'
