today:
139
yesterday:
311
Total:
1,018,378

General BOOLEAN SAMPLE

admin 2016.05.11 09:44 Views : 160

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
106 Delimiter admin 2016.04.29 148
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
104 Outer Join with Oracle SQL admin 2016.04.29 155
103 EXPORT & IMPORT admin 2016.05.01 191
102 wwv_flow_files admin 2016.05.01 168
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 150
99 EMPLOYEE_LEVEL_ID admin 2016.05.03 106
98 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247
97 Interactive Report admin 2016.05.07 138
96 Fundamentals of PL/SQL admin 2016.05.10 2053
95 Display Value, Return Value admin 2016.05.10 139
» BOOLEAN SAMPLE admin 2016.05.11 160
93 test admin 2016.05.11 143
92 CREATE VIEW admin 2016.05.13 241
91 3D Pie Chart admin 2016.05.17 235
90 TREE admin 2016.05.18 741
89 INSTR admin 2016.05.19 814
88 NVL admin 2016.05.19 175
87 ROWNUM admin 2016.05.19 255