today:
353
yesterday:
456
Total:
1,015,679

General BOOLEAN SAMPLE

admin 2016.05.11 09:44 Views : 155

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 145
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 233
104 Outer Join with Oracle SQL admin 2016.04.29 155
103 EXPORT & IMPORT admin 2016.05.01 184
102 wwv_flow_files admin 2016.05.01 160
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 143
99 EMPLOYEE_LEVEL_ID admin 2016.05.03 100
98 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 242
97 Interactive Report admin 2016.05.07 130
96 Fundamentals of PL/SQL admin 2016.05.10 2051
95 Display Value, Return Value admin 2016.05.10 135
» BOOLEAN SAMPLE admin 2016.05.11 155
93 test admin 2016.05.11 138
92 CREATE VIEW admin 2016.05.13 234
91 3D Pie Chart admin 2016.05.17 232
90 TREE admin 2016.05.18 732
89 INSTR admin 2016.05.19 798
88 NVL admin 2016.05.19 164
87 ROWNUM admin 2016.05.19 248