Funny SQL Query!

Tuesday, 2 June 2009

Just found this funny PL/SQL wedding query.Check it out.  

CREATE PROCEDURE MYMARRIAGE

@ BRIDEGROOM CHAR(NOTBAD) ,

@ BRIDE CHAR(GOOD)

AS BEGIN

SELECT BRIDE FROM INDIA_BRIDES

WHERE FATHERINLAW = 'MILLIONAIRE'

AND CARCOUNT > 2 AND HOUSESTATUS ='TWOSTOREYED'

AND BRIDEEDUSTATUS='PG ORABOVE'

AND HAVINGBROTHERS='NO'

AND HAVINGSISTERS ='NO'

AND ALLOWRELOCATE ='YES' 

SELECT GOLD ,CASH,CAR,BANKBALANE

FROM FATHERINLAW

UPDATE MYBANKACCOUT SET MYBAL = MYBAL + FATHERINLAWBAL

UPDATE MYLOCKER SET MYLOCKERCONTENTS = MYLOCKERCONTENTS + FATHERINLAWGOLD

INSERT INTO MYCARSHED VALUES ('BMW')

Then the wife writes the below query:

 

DROP HUSBAND

COMMIT;

  

ha ha ha ha..Enjoy!!!!!