Member Method

CREATE TYPE MenuType AS OBJECT (
	bar REF BarType, 
  	beer REF BeerType, 
  	price FLOAT,
MEMBER FUNCTION priceInYen(rate IN FLOAT)
RETURN FLOAT
)

//Type Body
CREATE TYPE BODY MenuType AS 
MEMBER FUNCTION
priceInYen(rate FLOAT)
RETURN FLOAT IS
BEGIN
	RETURN rate * SELF.price;
END;
END;

CREATE TABLE Sells OF MenuType;

//Adding new Member Method
ALTER TYPE MenuType
ADD MEMBER FUNCTION 
priceInUSD(rate FLOAT)
RETURN FLOAT 
CASCADE;


//Adding new Type Body
CREATE OR REPLACE TYPE BODY MenuType AS 
MEMBER FUNCTION
priceInYen(rate FLOAT)
RETURN FLOAT IS
BEGIN
	RETURN rate * SELF.price;
END priceInYen;

MEMBER FUNCTION
priceInUSD(rate FLOAT)
RETURN FLOAT IS
BEGIN
	RETURN rate * SELF.price;
END priceInUSD;
END;



SELECT s.beer.name, s.priceInYen(106.0) FROM Sells s
WHERE s.bar.name = 'Joe''s Bar';