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 |
|---|