today:
221
yesterday:
219
Total:
1,004,137

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;

I want to
Update Delete List
No. Subject Author Date Views
106 Delimiter admin 2016.04.29 141
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 220
104 Outer Join with Oracle SQL admin 2016.04.29 148
103 EXPORT & IMPORT admin 2016.05.01 175
102 wwv_flow_files admin 2016.05.01 155
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 116
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 133
» EMPLOYEE_LEVEL_ID admin 2016.05.03 89
98 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 234
97 Interactive Report admin 2016.05.07 118
96 Fundamentals of PL/SQL admin 2016.05.10 2038
95 Display Value, Return Value admin 2016.05.10 116
94 BOOLEAN SAMPLE admin 2016.05.11 147
93 test admin 2016.05.11 123
92 CREATE VIEW admin 2016.05.13 218
91 3D Pie Chart admin 2016.05.17 222
90 TREE admin 2016.05.18 722
89 INSTR admin 2016.05.19 789
88 NVL admin 2016.05.19 152
87 ROWNUM admin 2016.05.19 240
Write Tag