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;
/
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