OraFAQ Forum: SQL & PL/SQL

Thu, 12 July 2012 12:49

satheesh_ss
Messages: 54
Registered: July 2012

Member

select 10 from dual; y its showing all the rows with 10?

Thu, 12 July 2012 12:52

Michel Cadot
Messages: 54250
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Because it is what you asked.
What do you expect?

You not only have to read the Concepts manual but also the Database SQL Reference.

Regards
Michel

Thu, 12 July 2012 13:21

Solomon Yakobson
Messages: 1408
Registered: January 2010

Senior Member

satheesh_ss wrote on Thu, 12 July 2012 13:49

select 10 from dual; y its showing all the rows with 10?

ALL the rows? And how many do you get? I hope just one, otherwise you have corrupt database.

SY.

Thu, 12 July 2012 13:38

BlackSwan
Messages: 20112
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Mon, 16 July 2012 03:14

satheesh_ss
Messages: 54
Registered: July 2012

Member

Dear Solomon Yakobson,
you are right and i m getting a single row with a value 10...

Mon, 16 July 2012 06:31

cookiemonster
Messages: 9170
Registered: September 2008
Location: Rainy Manchester

Senior Member

So why are you asking the question?
Did you expect a different result?

Previous Topic:	Connect SQL and Oracle, possible?
Next Topic:	Compile Invalid Objects

Goto Forum:

]

Current Time: Sun May 26 00:25:39 CDT 2013

Total time taken to generate the page: 0.09806 seconds