today:
19
yesterday:
1,189
Total:
1,007,399

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
86 Global & Custom Serach file admin 2016.04.28 129
85 Null Display Value admin 2024.01.10 130
84 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 133
83 LAST DAY SQL admin 2024.01.19 135
82 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1 admin 2017.11.25 136
81 Oracle APEX 5.1.4 Installation admin 2018.04.17 138
80 How to Update Oracle XE admin 2018.04.25 139
79 Delimiter admin 2016.04.29 141
78 COUNT admin 2016.04.28 147
» BOOLEAN SAMPLE admin 2016.05.11 147
76 Outer Join with Oracle SQL admin 2016.04.29 148
75 Field Showing admin 2016.04.01 149
74 Column Data 일괄 추가 admin 2023.11.24 149
73 CREATE (INSERT) PROCESS admin 2016.04.28 151
72 NVL admin 2016.05.19 152
71 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
70 PHONE NUMBER admin 2016.04.28 153
69 MAX admin 2016.04.28 155
68 wwv_flow_files admin 2016.05.01 155
67 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157