today:
827
yesterday:
1,768
Total:
1,114,826

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

admin 2016.05.03 15:49 Views : 194

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
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 345
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 145
» HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 194
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 160
25 wwv_flow_files admin 2016.05.01 199
24 EXPORT & IMPORT admin 2016.05.01 285
23 Outer Join with Oracle SQL admin 2016.04.29 206
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 288
21 Delimiter admin 2016.04.29 188
20 SQL SELECT DISTINCT Statement admin 2016.04.29 234
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 221
18 COUNT admin 2016.04.28 206
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 246
16 CREATE (INSERT) PROCESS admin 2016.04.28 206
15 DELETE PROCESS admin 2016.04.28 222
14 Global & Custom Serach file admin 2016.04.28 187
13 INSERT PROCESS admin 2016.04.28 214
12 JAVA for delete admin 2016.04.28 203
11 LIST OF VALUE (DYNAMIC) admin 2016.04.28 181
10 MAX admin 2016.04.28 211