today:
123
yesterday:
242
Total:
1,004,281

SQL EMPLOYEE_LEVEL_ID

admin 2016.05.03 19:45 Views : 89

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
26 Material requirements planning (MRP) admin 2018.02.14 88
25 Reversing Require HTTPS admin 2023.06.04 85
24 Link- AbbaBeauty admin 2018.02.13 85
23 127.0.0.1:8080/apex/ admin 2023.06.03 84
22 STARTUP admin 2022.09.01 84
21 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 81
20 Manufacturing resource planning (MRP II) admin 2018.02.14 78
19 ipconfig admin 2023.06.03 68
18 Building Mobile Applications with Oracle Application Express 5.0 admin 2017.11.25 67
17 GP - 영수증 (2) admin 2022.11.07 63
16 GP 영수증 본문 admin 2022.11.07 62
15 CHANGE TABLE NAME admin 2023.05.31 60
14 WHDR email address admin 2023.04.13 56
13 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
12 LOOP TABLE UPDATE admin 2023.05.19 52
11 FINAL TEST admin 2023.05.08 46
10 Global pages admin 2023.05.09 42
9 GitHub.com/Oracle/APEX. admin 2023.05.04 42
8 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 41
7 TEST admin 2023.04.28 41