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

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
41 Field Showing admin 2016.04.01 160
40 UPDATE PROCESS admin 2016.04.28 188
» PHONE NUMBER admin 2016.04.28 168
38 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