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'