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?
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: 8625
Registered: November 2002
Location: California, USA
Senior Member
It is an "outer join".
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
Previous Topic: Poor Performance of aggregate Function
Next Topic: PLS-00457:"expressions have to be of SQL types"
Goto Forum:
  


Current Time: Sun Dec 04 20:48:40 CST 2016

Total time taken to generate the page: 0.09816 seconds