FilesExpand file tree

master

/

authorized_emps_4.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

31 lines (27 loc) · 802 Bytes

master

/

authorized_emps_4.sql

Copy path

Top

File metadata and controls

• Code
• Blame

31 lines (27 loc) · 802 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

create or replace function authorized_emps

(

p_schema_name in varchar2,

p_object_name in varchar2

)

return varchar2

is

l_deptno number;

l_return_val varchar2(2000);

begin

if (p_schema_name = USER) then

l_return_val := null;

else

select deptno

into l_deptno

from emp

where ename = SYS_CONTEXT ('WEB_CTX','WEBUSER');

l_return_val := 'DEPTNO = '||l_deptno;

end if;

return l_return_val;

end;

/*======================================================================

| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven

| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc.

| To submit corrections or find more code samples visit

| http://oreilly.com/catalog/9780596514464/

*/