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

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
Messages: 2818
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: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the guide and try to do your homework yourself.

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

Current Time: Thu Oct 27 00:18:33 CDT 2016

Total time taken to generate the page: 0.13642 seconds