Ack :~ Chintan Vasani

CREATE OR REPLACE PROCEDURE MyMarriage @BrideGroom CHAR(NotBad), @Bride CHAR(Good) IS
SELECT Bride
FROM *****Brides –this is ur guess reply with this
WHERE FatherInLaw = ‘Millionaire’
AND CarCount = 2
AND HouseStatus =’TwoStoreyed’
AND BrideEduStatus=’PGorAbove’ HavingBrothers=’NO’ AND HavingSisters =’No’ AND AllowRelocate =’YES’ ;

SELECT gold, cash, car, bankbalance
FROM fatherinlaw;

UPDATE mybankaccout
SET mybal = mybal + fatherinlawbal;

UPDATE mylocker
SET mylockercontents = mylockercontents + fatherinlawgold;

INSERT INTO mycarshed
VALUES (‘Safari’);

END;