drop table as_usersORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table as_users
as
select rownum id, dbms_random.string('x',10) name
from dual
connect by rownum <= 10Table created.
create or replace function get_users (pnUserId number)
return varchar2 sql_macro
is
begin
if pnUserId is not null then
return 'select * from as_users where id = pnUserId';
else
return 'select * from as_users';
end if;
end get_users; Function created.
select *
from get_users(null)| ID | NAME |
|---|---|
| 1 | XUQNU9WNWX |
| 2 | L7J2LALM35 |
| 3 | MRAIZ86M7Q |
| 4 | HXGY3THG3Z |
| 5 | N5G0P2GTHO |
| 6 | 4D0IKABQS1 |
| 7 | 9ND9PVEBAX |
| 8 | 33BE3231Q4 |
| 9 | EZDG1HC2N9 |
| 10 | GD14QFKO2L |
select *
from get_users(5)| ID | NAME |
|---|---|
| 5 | N5G0P2GTHO |