The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, MARCIN.
Asked: September 09, 2025 - 9:51 am UTC
Last updated: September 17, 2025 - 3:09 pm UTC
Version: 19c
Viewed 100+ times
create or replace procedure p as begin null; end; / select created, last_ddl_time from user_objects where object_name = 'P'; CREATED LAST_DDL_TIME -------------------- -------------------- 17-SEP-2025 14:04:58 17-SEP-2025 14:04:58 exec dbms_session.sleep ( 7 ); create or replace procedure p as begin dbms_output.put_line ( 'stuff' ); end; / select created, last_ddl_time from user_objects where object_name = 'P'; CREATED LAST_DDL_TIME -------------------- -------------------- 17-SEP-2025 14:04:58 17-SEP-2025 14:05:05
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library