today:
66,747
yesterday:
36,263
Total:
9,694,243

Oracle APEX SQL

SQL HEAD TITLE (제목)을 조건에 따라 바꾸기

admin 2016.05.03 14:49 Views : 1224

DECLARE

NAME_sv   VARCHAR2(30);
--Detail_sv VARCHAR2(30) := 'Change Details';
BEGIN

if :P18_CREATE_SW = 0 then
select ENAME  into NAME_sv  from emp where  EMPNO = :p18_EMPNO;
:P18_NAME := initCap(NAME_sv);
:p18_head_detail := ' * Modfy Detail Customer';

else

:p18_head_detail := ' Add Detail Customer';
:P18_NAME := ' ';

end if;

END;

No. Subject Author Date Views
32 Display Value, Return Value admin 2016.05.10 1198
31 Fundamentals of PL/SQL admin 2016.05.10 3335
30 Interactive Report admin 2016.05.07 1145
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 1392
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 1144
» HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 1224
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 1040
25 wwv_flow_files admin 2016.05.01 1232
24 EXPORT & IMPORT admin 2016.05.01 1391
23 Outer Join with Oracle SQL admin 2016.04.29 1270
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 1391
21 Delimiter admin 2016.04.29 1249
20 SQL SELECT DISTINCT Statement admin 2016.04.29 1474
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 1268
18 COUNT admin 2016.04.28 1260
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 1269
16 CREATE (INSERT) PROCESS admin 2016.04.28 1266
15 DELETE PROCESS admin 2016.04.28 1275
14 Global & Custom Serach file admin 2016.04.28 1454
13 INSERT PROCESS admin 2016.04.28 1276