编译(compile)对象

1、编译包
alter package test.test_PKG compile body;
alter package test.test_PKG compile body;

2、编译存储过程
alter procedure test.P_T_HR_SALARYLIST compile;

3.编译函数
ALTER FUNCTION test.IN_LIST COMPILE;

4.编译视图
alter  view view_name compile;