Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from all_statements;
create or replace function double( p_in integer )
  return integer
as
  l_val integer;
begin
  select p_in * 2
    into l_val
    from dual;
    
  return l_val;
end;
/
select * from all_statements;
alter function double compile;
select * from all_statements;
ALTER SESSION SET PLSCOPE_SETTINGS='IDENTIFIERS:ALL';
alter function double compile;
select * from all_statements;


OWNER
SIGNATURE
TYPE
OBJECT_NAME
OBJECT_TYPE
USAGE_ID
LINE
COL
USAGE_CONTEXT_ID
SQL_ID
HAS_HINT
HAS_INTO_BULK
HAS_INTO_RETURNING
HAS_INTO_RECORD
HAS_CURRENT_OF
HAS_FOR_UPDATE
HAS_IN_BINDS
TEXT
FULL_TEXT
ORIGIN_CON_ID


FIDDLE_IVNFYOMADZGKLELUMSVL
72FDC9BB75EC0329810C52633C572970
SELECT
DOUBLE
FUNCTION
8
6
3
2
23qbgtjqmh9tf
NO
NO
NO
NO
NO
NO
YES
SELECT :B1 * 2 FROM DUAL
SELECT :B1 * 2 FROM DUAL
3