today:
2
yesterday:
219
Total:
1,003,401

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
106 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 81
105 STARTUP admin 2022.09.01 84
104 127.0.0.1:8080/apex/ admin 2023.06.03 84
103 Link- AbbaBeauty admin 2018.02.13 85
102 Reversing Require HTTPS admin 2023.06.04 85
101 Material requirements planning (MRP) admin 2018.02.14 88
» EMPLOYEE_LEVEL_ID admin 2016.05.03 89
99 image (products) admin 2017.11.24 94
98 TEST admin 2023.03.27 97
97 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 100
96 SQL DEVELOPER file admin 2022.03.17 106
95 QR-CODE admin 2017.11.30 112
94 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 116
93 Display Value, Return Value admin 2016.05.10 116
92 Interactive Report admin 2016.05.07 118
91 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 120
90 What Is ERP? admin 2018.02.14 121
89 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 121
88 Null Display Value admin 2024.01.10 121
87 test admin 2016.05.11 123