Wednesday 28 March 2012

Function to get the customer name by passing customer id as parameter

CREATE OR REPLACE FUNCTION getcustomer(p1 IN NUMBER) RETURN VARCHAR2 AS
v_customer VARCHAR2(100);
BEGIN
SELECT DISTINCT customer_name INTO v_vendor FROM ra_customers
WHERE customer_id=p1;
RETURN v_customer;
END;
/

No comments:

Post a Comment