OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » query (oracle9i)

Tue, 03 March 2009 07:51

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?

Tue, 03 March 2009 07:58

pablolee
Messages: 2882
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]

Tue, 03 March 2009 08:10

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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: Mon Feb 17 20:53:59 CST 2025