Oracle 21c

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

create table t(id, val)
as
select level, mod(level, 4)
from dual
connect by level < 10
9 rows affected

create function f_do_smth(
  p1 int, p2 in int
) return timestamp
is
begin
  /*To demonstrate some work*/
  dbms_session.sleep(trunc(p1+p2)/10);
  return systimestamp;
end;/
create function f_get_t_byval (
  p_val in int
) return varchar2
sql_macro(table)
is
begin
  return '
    select
      t.*,
      f_do_smth(
        p1 => t.id,
        /*Here we use a parameter as a parameter
          for processing, not only as a filter*/
        p2 => f_get_t_byval.p_val
      ) as processed_result
    from t
    where val >= f_get_t_byval.p_val
  ';
end;/
select *
from user_errors
select *
from f_get_t_byval(p_val => 2)


ID
VAL
PROCESSED_RESULT


2
2
16-NOV-22 22.18.31.164939000

3
3
16-NOV-22 22.18.31.668203000

6
2
16-NOV-22 22.18.32.508269000

7
3
16-NOV-22 22.18.33.468175000

ID	VAL	PROCESSED_RESULT
2	2	16-NOV-22 22.18.31.164939000
3	3	16-NOV-22 22.18.31.668203000
6	2	16-NOV-22 22.18.32.508269000
7	3	16-NOV-22 22.18.33.468175000