today:
641
yesterday:
1,155
Total:
1,131,811

General BOOLEAN SAMPLE

admin 2016.05.11 10:44 Views : 185

declare
  v_access_level  number;
begin
  select e.employee_level_id  into  v_access_level
   from EMP  e
   where  lower(e.ou_name) = lower ('&USER.');
  if  v_access_level in (1,4)  then
      return  true;
  end if;

 EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         RETURN false;   
end;

No. Subject Author Date Views
49 Assign a network host to Access Control List admin 2016.06.07 385
48 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 408
47 CREATE_ACL (1st STEP) admin 2016.06.07 355
46 ACL 보기 admin 2016.06.07 351
45 Oracle 11g Access Control List for External Network Services admin 2016.06.07 340
44 Access Control List (ACL) admin 2016.06.07 405
43 CAPTCHA PLUG-IN admin 2016.05.27 364
42 SUBSTR admin 2016.05.26 324
41 FOR LOOP admin 2016.05.20 329
40 ROWNUM admin 2016.05.19 290
39 NVL admin 2016.05.19 207
38 INSTR admin 2016.05.19 872
37 TREE admin 2016.05.18 816
36 3D Pie Chart admin 2016.05.17 300
35 CREATE VIEW admin 2016.05.13 302
34 test admin 2016.05.11 210
» BOOLEAN SAMPLE admin 2016.05.11 185
32 Display Value, Return Value admin 2016.05.10 185
31 Fundamentals of PL/SQL admin 2016.05.10 2114
30 Interactive Report admin 2016.05.07 162