today:
281
yesterday:
288
Total:
1,017,267

SQL EMPLOYEE_LEVEL_ID

admin 2016.05.03 19:45 Views : 105

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
106 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 88
105 Link- AbbaBeauty admin 2018.02.13 92
104 Material requirements planning (MRP) admin 2018.02.14 96
103 127.0.0.1:8080/apex/ admin 2023.06.03 96
102 Reversing Require HTTPS admin 2023.06.04 100
» EMPLOYEE_LEVEL_ID admin 2016.05.03 105
100 image (products) admin 2017.11.24 105
99 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 106
98 STARTUP admin 2022.09.01 108
97 TEST admin 2023.03.27 114
96 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
95 QR-CODE admin 2017.11.30 125
94 What Is ERP? admin 2018.02.14 125
93 SQL DEVELOPER file admin 2022.03.17 128
92 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 130
91 Interactive Report admin 2016.05.07 138
90 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
89 Display Value, Return Value admin 2016.05.10 139
88 test admin 2016.05.11 143
87 Global & Custom Serach file admin 2016.04.28 144