Posted By

wh0emPah on 03/28/10


Tagged


Versions (?)

blablabla


 / Published in: PL/SQL
 

  1. PROCEDURE P1_1_VOEG_KLANT_TOE
  2. (
  3. p_id IN S_CUSTOMER.ID%TYPE,
  4. p_name IN S_CUSTOMER.NAME%TYPE,
  5. p_phone IN S_CUSTOMER.PHONE%TYPE,
  6. p_address IN S_CUSTOMER.ADDRESS%TYPE,
  7. p_city IN S_CUSTOMER.CITY%TYPE,
  8. p_state IN S_CUSTOMER.STATE%TYPE,
  9. p_country IN S_CUSTOMER.COUNTRY%TYPE,
  10. p_zipcode IN S_CUSTOMER.ZIP_CODE%TYPE
  11. )
  12.  
  13. INSERT INTO S_CUSTOMER(ID, NAME, PHONE, address, city, state, country,ZIP_CODE)
  14. VALUES (p_id,p_name,P_PHONE,P_ADDRESS,P_CITY,P_STATE,P_COUNTRY,P_ZIPCODE);
  15. END P1_1_VOEG_KLANT_TOE;

Report this snippet  

You need to login to post a comment.