today:
1,179
yesterday:
1,189
Total:
1,008,559

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 INSERT PROCESS admin 2016.04.28 160
65 DELETE PROCESS admin 2016.04.28 161
64 SQL SELECT DISTINCT Statement admin 2016.04.29 163
63 JAVA for delete admin 2016.04.28 165
62 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 166
61 UPDATE PROCESS admin 2016.04.28 169
60 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 169
59 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
58 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 173
57 EXPORT & IMPORT admin 2016.05.01 175
56 CREATE TABLESPACE admin 2016.04.28 179
55 Captcha Test file admin 2016.04.18 180
54 Apex setup procedure admin 2016.04.28 182
53 TABLE PRINT admin 2018.06.18 188
52 How to convert DATE to NUMBER admin 2018.05.27 199
51 MISSIONARY_SUB admin 2018.06.25 203
50 Name Show admin 2016.04.28 204
49 use a validation function for an element in apex 5.0 admin 2018.05.19 210
48 IF/ELSE ... CASE WHEN admin 2018.06.25 210
47 All Data DELETE from Table admin 2018.05.10 211