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: 26766
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: 21823
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: 2882
Registered: May 2007
Location: Scotland
Senior Member
/forum/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: 2103
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sun Feb 09 20:53:05 CST 2025