today:
124
yesterday:
311
Total:
1,018,363

SQL Name Show

admin 2016.04.28 13:19 Views : 217

* Degignated People Name Show *


DECLARE

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

if :P9_CREATE_SW = 0 then
    select CUST_LAST_NAME || ', ' || CUST_FIRST_NAME AS NAME into NAME_sv 
    from DEMO_CUSTOMERS    where CUSTOMER_ID = :p9_CUSTOMER_ID;
   :P9_NAME := initCap(NAME_sv);
   :p9_head_detail := ' * Modfy Detail Customer';
else
   :p9_head_detail := ' Add Detail Customer';
    :P9_NAME := ' ';
end if;

exception     
  when no_data_found or TOO_MANY_ROWS then
      :P9_NAME := ' ';

END;

No. Subject Author Date Views
41 Field Showing admin 2016.04.01 160
40 UPDATE PROCESS admin 2016.04.28 188
39 PHONE NUMBER admin 2016.04.28 168
» Name Show admin 2016.04.28 217
37 MAX admin 2016.04.28 174
36 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
35 INSERT PROCESS admin 2016.04.28 176
34 Global & Custom Serach file admin 2016.04.28 144
33 DELETE PROCESS admin 2016.04.28 180
32 CREATE (INSERT) PROCESS admin 2016.04.28 167
31 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
30 COUNT admin 2016.04.28 170
29 SQL SELECT DISTINCT Statement admin 2016.04.29 173
28 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
27 Outer Join with Oracle SQL admin 2016.04.29 155
26 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 150
25 EMPLOYEE_LEVEL_ID admin 2016.05.03 106
24 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247
23 Display Value, Return Value admin 2016.05.10 139
22 CREATE VIEW admin 2016.05.13 241