Home » Other » Community Hangout » joke-wedding query
joke-wedding query [message #282989] Sun, 25 November 2007 21:41 Go to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
WeddingQuery. ...... .......
CREATE PROCEDURE MyMarriage BrideGroom Male (25) , Bride Female(20) AS 
BEGIN SELECT Bride FROM native_Brides 
WHERE FatherInLaw = 'Millionaire' AND Count(Car) > 20 
AND HouseStatus ='ThreeStoreyed' 
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) 
AND Having Brothers is Null AND Sisters is Null; 


SELECT Gold ,Cash,Car,BankBalan ce 
FROM FatherInLaw; 

UPDATE MyBankAccout SET MyBal = MyBal + FatherInLawBal; 

UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherInLawGold; 

INSERT INTO MyCarShed VALUES ('BMW'); 
END; 

GO Then the wife writes the below query:
DROP user HUSBAND; 
Commit;

[Updated on: Sun, 25 November 2007 21:44]

Report message to a moderator

Re: joke-wedding query [message #283013 is a reply to message #282989] Sun, 25 November 2007 23:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Great!
Re: joke-wedding query [message #283015 is a reply to message #282989] Sun, 25 November 2007 23:29 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I just hope it is not
DROP user HUSBAND dead;
Re: joke-wedding query [message #283018 is a reply to message #283015] Sun, 25 November 2007 23:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

LOL,
but it should be "CASCADE"...Smile

ORA-01922: CASCADE must be specified to drop 'HASBAND'
Re: joke-wedding query [message #283021 is a reply to message #282989] Sun, 25 November 2007 23:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After DDL(Drop User) commit is redundant.

Laughing Laughing
Re: joke-wedding query [message #283023 is a reply to message #283021] Sun, 25 November 2007 23:36 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Arju wrote on Mon, 26 November 2007 11:33

After DDL(Drop User) commit is redundant.

Laughing Laughing

Thanks.
Re: joke-wedding query [message #283456 is a reply to message #282989] Tue, 27 November 2007 03:47 Go to previous message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Quote:

After DDL(Drop User) commit is redundant.




After

DROP user HUSBAND; 


Husband may 'Commit' sucide!

Kiran.

[Updated on: Tue, 27 November 2007 03:49]

Report message to a moderator

Previous Topic: Happy Thanksgiving in advance
Next Topic: Funniest (merged by LF)
Goto Forum:
  


Current Time: Fri Dec 09 04:21:30 CST 2016

Total time taken to generate the page: 0.31613 seconds