Home » SQL & PL/SQL » SQL & PL/SQL » no rows (SQL*PLUS)
no rows [message #341052] Fri, 15 August 2008 18:16 Go to next message
hunkguy1@gmail.com
Messages: 1
Registered: August 2008
Location: hydrabad
Junior Member

HI,
GOODMORNING,
I WAS TRY TO JOIN THE 2 TABLES IN EQUIJOIN CONSEPT BUT THE OUTPUT
IS NOROWS SO,WHAT IS THE SOLUTION FOR THESE
THANKS&REGARDS
PRADEEP.P Laughing

Re: no rows [message #341053 is a reply to message #341052] Fri, 15 August 2008 18:18 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Please get you Caps Lock key fixed. It seems to be stuck ON!
Re: no rows [message #341068 is a reply to message #341052] Sat, 16 August 2008 00:02 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A solution might be to properly join these tables. Or, another solution might be to use outer join. Or, perhaps there really is nothing to return.
Re: no rows [message #341103 is a reply to message #341052] Sat, 16 August 2008 09:11 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
./fa/1659/0/
Put some rows in the tables?
Re: no rows [message #341326 is a reply to message #341103] Mon, 18 August 2008 06:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you were feeling particularly daring, you could een try poting the SQL you used, along with details of the tables, and the data.....

{typo}

[Updated on: Mon, 18 August 2008 06:58]

Report message to a moderator

Re: no rows [message #341386 is a reply to message #341052] Mon, 18 August 2008 12:07 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
There is no flaw in any of the code you have posted.

Kevin
Re: no rows [message #341387 is a reply to message #341386] Mon, 18 August 2008 12:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Laughing

Previous Topic: Trying to query multiple rows into multiple columns
Next Topic: Date Calculation with Oracle
Goto Forum:
  


Current Time: Sat Dec 03 10:06:16 CST 2016

Total time taken to generate the page: 0.12233 seconds