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;