today:
298
yesterday:
183
Total:
1,001,903

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

admin 2016.05.03 14:49 Views : 133

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
46 ACL 보기 admin 2016.06.07 309
45 Oracle 11g Access Control List for External Network Services admin 2016.06.07 302
44 Access Control List (ACL) admin 2016.06.07 343
43 CAPTCHA PLUG-IN admin 2016.05.27 299
42 SUBSTR admin 2016.05.26 272
41 FOR LOOP admin 2016.05.20 269
40 ROWNUM admin 2016.05.19 240
39 NVL admin 2016.05.19 152
38 INSTR admin 2016.05.19 785
37 TREE admin 2016.05.18 722
36 3D Pie Chart admin 2016.05.17 222
35 CREATE VIEW admin 2016.05.13 218
34 test admin 2016.05.11 123
33 BOOLEAN SAMPLE admin 2016.05.11 147
32 Display Value, Return Value admin 2016.05.10 116
31 Fundamentals of PL/SQL admin 2016.05.10 2037
30 Interactive Report admin 2016.05.07 118
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 219
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 89
» HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 133