Home » SQL & PL/SQL » SQL & PL/SQL » Oracle hint?
Oracle hint? [message #203326] Tue, 14 November 2006 15:50 Go to next message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
Hello, what does the following mean in a SQL statement (after b.store_nbr)?
WHERE 
... 
AND a.store_nbr = b.store_nbr(+);
It is hard looking for information on it as "(+)" isn't search friendly. Is it some kind of hint?

Report message to a moderator

Re: Oracle hint? [message #203327 is a reply to message #203326] Tue, 14 November 2006 15:52 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
It is an "outer join".

Report message to a moderator

Re: Oracle hint? [message #203330 is a reply to message #203326] Tue, 14 November 2006 15:57 Go to previous message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
Ah, thanks. Smile

Report message to a moderator

Previous Topic: Poor Performance of aggregate Function
Next Topic: PLS-00457:"expressions have to be of SQL types"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 09:40:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.