today:
64,278
yesterday:
36,263
Total:
9,691,774

Oracle APEX SQL

SQL EMPLOYEE_LEVEL_ID

admin 2016.05.03 19:45 Views : 1144

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;
      else
      return false;
  end if;

 EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         RETURN false; 
end;

No. Subject Author Date Views
32 Display Value, Return Value admin 2016.05.10 1198
31 Fundamentals of PL/SQL admin 2016.05.10 3335
30 Interactive Report admin 2016.05.07 1145
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 1392
» EMPLOYEE_LEVEL_ID admin 2016.05.03 1144
27 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 1224
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 1040
25 wwv_flow_files admin 2016.05.01 1232
24 EXPORT & IMPORT admin 2016.05.01 1391
23 Outer Join with Oracle SQL admin 2016.04.29 1270
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 1391
21 Delimiter admin 2016.04.29 1249
20 SQL SELECT DISTINCT Statement admin 2016.04.29 1474
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 1268
18 COUNT admin 2016.04.28 1260
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 1269
16 CREATE (INSERT) PROCESS admin 2016.04.28 1266
15 DELETE PROCESS admin 2016.04.28 1275
14 Global & Custom Serach file admin 2016.04.28 1454
13 INSERT PROCESS admin 2016.04.28 1276