today:
148
yesterday:
311
Total:
1,018,387

SQL PHONE NUMBER

admin 2016.04.28 13:16 Views : 168

* PHONE NUMBER *
Begin
 
if :P9_CREATE_SW = 0 then


for c1 in  (

  Select  CUSTOMER_ID, PHONE_NUMBER1  from DEMO_CUSTOMERS
)

loop

  if  c1.CUSTOMER_ID = :p9_CUSTOMER_ID then
      :p9_PHONE_NUMBER1   := c1.PHONE_NUMBER1; 
  end if;
end loop;

end if;

end;

No. Subject Author Date Views
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
25 wwv_flow_files admin 2016.05.01 168
24 EXPORT & IMPORT admin 2016.05.01 191
23 Outer Join with Oracle SQL admin 2016.04.29 155
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
21 Delimiter admin 2016.04.29 148
20 SQL SELECT DISTINCT Statement admin 2016.04.29 173
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 179
18 COUNT admin 2016.04.28 170
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
16 CREATE (INSERT) PROCESS admin 2016.04.28 167
15 DELETE PROCESS admin 2016.04.28 180
14 Global & Custom Serach file admin 2016.04.28 144
13 INSERT PROCESS admin 2016.04.28 176
12 JAVA for delete admin 2016.04.28 181
11 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
10 MAX admin 2016.04.28 174
9 Name Show admin 2016.04.28 217
» PHONE NUMBER admin 2016.04.28 168
7 UPDATE PROCESS admin 2016.04.28 188