Oracle10g中过程(PROCEDURE )重建的增强
2007-06-02 16:03:11 来源:WEB开发网在Oracle9i中,即使一个完全相同的过程的重建,Oracle也需要重新编译过程,这个可以从LAST_DDL_TIME看出:
[oracle@jumper oracle]$ sqlplus eygle/eygleSQL*Plus: Release 9.2.0.4.0 - Production on Sat Mar 31 17:52:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - ProductionSQL> create or replace PROCEDURE pining
2 IS
3 BEGIN
4 NULL;
5 END;
6 /Procedure created.
SQL> select object_name,last_ddl_time from dba_objects where object_name='PINING';
OBJECT_NAME LAST_DDL_TIME
------------------------------ -------------------
PINING 2007-03-31 17:52:58SQL> create or replace PROCEDURE pining
2 IS
3 BEGIN
4 NULL;
5 END;
6 /Procedure created.
SQL> select object_name,last_ddl_time from dba_objects where object_name='PINING';
OBJECT_NAME LAST_DDL_TIME
------------------------------ -------------------
PINING 2007-03-31 17:54:35
更多精彩
赞助商链接