Home » SQL & PL/SQL » SQL & PL/SQL » Table
Table [message #560430] Thu, 12 July 2012 12:49 Go to next message
satheesh_ss
Messages: 61
Registered: July 2012
Member
select 10 from dual; y its showing all the rows with 10?
Re: Table [message #560432 is a reply to message #560430] Thu, 12 July 2012 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: Table [message #560436 is a reply to message #560430] Thu, 12 July 2012 13:21 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2504
Registered: January 2010
Location: Connecticut, USA
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.
Re: Table [message #560438 is a reply to message #560436] Thu, 12 July 2012 13:38 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Table [message #560642 is a reply to message #560438] Mon, 16 July 2012 03:14 Go to previous messageGo to next message
satheesh_ss
Messages: 61
Registered: July 2012
Member
Dear Solomon Yakobson,
you are right and i m getting a single row with a value 10...
Re: Table [message #560677 is a reply to message #560642] Mon, 16 July 2012 06:31 Go to previous message
cookiemonster
Messages: 12422
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: Thu Dec 08 22:14:07 CST 2016

Total time taken to generate the page: 0.25763 seconds