today:
78
yesterday:
174
Total:
999,558

General BOOLEAN SAMPLE

admin 2016.05.11 09:44 Views : 144

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
19 CREATE_ACL (1st STEP) admin 2016.06.07 305
18 ACL 보기 admin 2016.06.07 307
17 Oracle 11g Access Control List for External Network Services admin 2016.06.07 294
16 Access Control List (ACL) admin 2016.06.07 335
15 CAPTCHA PLUG-IN admin 2016.05.27 291
14 3D Pie Chart admin 2016.05.17 214
13 test admin 2016.05.11 121
» BOOLEAN SAMPLE admin 2016.05.11 144
11 Fundamentals of PL/SQL admin 2016.05.10 2031
10 Interactive Report admin 2016.05.07 116
9 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 108
8 wwv_flow_files admin 2016.05.01 147
7 EXPORT & IMPORT admin 2016.05.01 166
6 Delimiter admin 2016.04.29 133
5 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 158
4 Apex setup procedure admin 2016.04.28 180
3 CREATE TABLESPACE admin 2016.04.28 170
2 Captcha Test file admin 2016.04.18 176
1 How-To Document / Change a Logo in a Page Template admin 2016.04.16 219