Home » SQL & PL/SQL » SQL & PL/SQL » query (oracle9i)
query [message #389745] Tue, 03 March 2009 07:51 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
table1 table2
sno sno
1 1
2 2
NULL


Select COUNT(*) from table1,table2;

How many rows the query returns?
Re: query [message #389749 is a reply to message #389745] Tue, 03 March 2009 07:58 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Try it and see
(and once you have, explain the results)

[Updated on: Tue, 03 March 2009 07:58]

Report message to a moderator

Re: query [message #389756 is a reply to message #389745] Tue, 03 March 2009 08:10 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the guide and try to do your homework yourself.

Regards
Michel
Previous Topic: ptocedure restore
Next Topic: query2
Goto Forum:
  


Current Time: Sat Dec 03 01:10:00 CST 2016

Total time taken to generate the page: 0.12249 seconds