today:
285
yesterday:
183
Total:
1,001,890

General BOOLEAN SAMPLE

admin 2016.05.11 09:44 Views : 147

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;
  end if;

 EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         RETURN false;   
end;

No. Subject Author Date Views
66 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 166
65 JAVA for delete admin 2016.04.28 162
64 SQL SELECT DISTINCT Statement admin 2016.04.29 161
63 INSERT PROCESS admin 2016.04.28 160
62 DELETE PROCESS admin 2016.04.28 158
61 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
60 wwv_flow_files admin 2016.05.01 155
59 MAX admin 2016.04.28 155
58 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 153
57 PHONE NUMBER admin 2016.04.28 153
56 NVL admin 2016.05.19 152
55 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 151
54 CREATE (INSERT) PROCESS admin 2016.04.28 151
53 Field Showing admin 2016.04.01 149
52 Outer Join with Oracle SQL admin 2016.04.29 148
» BOOLEAN SAMPLE admin 2016.05.11 147
50 COUNT admin 2016.04.28 146
49 Delimiter admin 2016.04.29 141
48 How to Update Oracle XE admin 2018.04.25 139
47 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1 admin 2017.11.25 136