today:
141
yesterday:
311
Total:
1,018,380

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
66 NVL admin 2016.05.19 175
65 INSERT PROCESS admin 2016.04.28 176
64 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 179
63 DELETE PROCESS admin 2016.04.28 180
62 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 181
61 JAVA for delete admin 2016.04.28 181
60 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
59 UPDATE PROCESS admin 2016.04.28 188
58 EXPORT & IMPORT admin 2016.05.01 191
57 Captcha Test file admin 2016.04.18 192
56 CREATE TABLESPACE admin 2016.04.28 192
55 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 195
54 Apex setup procedure admin 2016.04.28 198
53 TABLE PRINT admin 2018.06.18 210
» Name Show admin 2016.04.28 217
51 How to convert DATE to NUMBER admin 2018.05.27 217
50 MISSIONARY_SUB admin 2018.06.25 223
49 IF/ELSE ... CASE WHEN admin 2018.06.25 223
48 use a validation function for an element in apex 5.0 admin 2018.05.19 226
47 All Data DELETE from Table admin 2018.05.10 231