today:
143
yesterday:
179
Total:
1,001,239

SQL Name Show

admin 2016.04.28 13:19 Views : 203

* 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 Monthly SUM admin 2023.05.22 37
40 LOOP TABLE UPDATE admin 2023.05.19 50
39 STARTUP admin 2022.09.01 83
38 EMPLOYEE_LEVEL_ID admin 2016.05.03 88
37 Display Value, Return Value admin 2016.05.10 115
36 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 120
35 LIST OF VALUE (DYNAMIC) admin 2016.04.28 126
34 Global & Custom Serach file admin 2016.04.28 127
33 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 132
32 How to Update Oracle XE admin 2018.04.25 138
31 COUNT admin 2016.04.28 145
30 Outer Join with Oracle SQL admin 2016.04.29 147
29 Field Showing admin 2016.04.01 148
28 CREATE (INSERT) PROCESS admin 2016.04.28 150
27 NVL admin 2016.05.19 151
26 PHONE NUMBER admin 2016.04.28 152
25 MAX admin 2016.04.28 154
24 DELETE PROCESS admin 2016.04.28 157
23 INSERT PROCESS admin 2016.04.28 159
22 SQL SELECT DISTINCT Statement admin 2016.04.29 160