Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE OR REPLACE procedure malath_test as
begin
DBMS_OUTPUT.put_line('test malath');
DBMS_OUTPUT.put_line('test malath2');
end;
/
select object_name, object_type,
  to_char(last_ddl_time, 'YYYY-MM-DD HH24:MI:SS') as last_ddl_time,
  timestamp
from user_objects


OBJECT_NAME
OBJECT_TYPE
LAST_DDL_TIME
TIMESTAMP


MALATH_TEST
PROCEDURE
2023-12-27 23:46:56
2023-12-27:23:46:56


-- sleep for 3 seconds
begin
  dbms_session.sleep(3);
end;
/
1 rows affected

-- recreate the procedure exactly as it was
CREATE OR REPLACE procedure malath_test as
begin
DBMS_OUTPUT.put_line('test malath');
DBMS_OUTPUT.put_line('test malath2');
end;
/
-- last_ddl_time does not change
select object_name, object_type,
  to_char(last_ddl_time, 'YYYY-MM-DD HH24:MI:SS') as last_ddl_time,
  timestamp
from user_objects


OBJECT_NAME
OBJECT_TYPE
LAST_DDL_TIME
TIMESTAMP


MALATH_TEST
PROCEDURE
2023-12-27 23:46:56
2023-12-27:23:46:56


-- sleep for 3 seconds
begin
  dbms_session.sleep(3);
end;
/
1 rows affected

-- recreate the procedure with trivial change (whitespace)
CREATE OR REPLACE procedure malath_test as
begin
  DBMS_OUTPUT.put_line('test malath');
  DBMS_OUTPUT.put_line('test malath2');
end;
/
-- last_ddl_time does change
select object_name, object_type,
  to_char(last_ddl_time, 'YYYY-MM-DD HH24:MI:SS') as last_ddl_time,
  timestamp
from user_objects


OBJECT_NAME
OBJECT_TYPE
LAST_DDL_TIME
TIMESTAMP


MALATH_TEST
PROCEDURE
2023-12-27 23:47:03
2023-12-27:23:47:03