today:
680
yesterday:
752
Total:
1,070,574

SQL EMPLOYEE_LEVEL_ID

admin 2016.05.03 19:45 Views : 145

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
109 Material requirements planning (MRP) admin 2018.02.14 111
108 Apex Interactive Report: The difference between CIR and RIR admin 2018.01.26 114
107 Monthly SUM admin 2023.05.22 117
106 image (products) admin 2017.11.24 119
105 127.0.0.1:8080/apex/ admin 2023.06.03 120
104 SQL Basics - Lesson 1 - Introduction admin 2017.06.17 127
103 LOOP TABLE UPDATE admin 2023.05.19 130
102 Reversing Require HTTPS admin 2023.06.04 131
101 What Is ERP? admin 2018.02.14 136
100 QR-CODE admin 2017.11.30 143
» EMPLOYEE_LEVEL_ID admin 2016.05.03 145
98 STARTUP admin 2022.09.01 145
97 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 150
96 TEST admin 2023.03.27 154
95 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 160
94 Interactive Report admin 2016.05.07 162
93 SQL DEVELOPER file admin 2022.03.17 163
92 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1 admin 2017.11.25 167
91 Display Value, Return Value admin 2016.05.10 169
90 test admin 2016.05.11 171