Home » SQL & PL/SQL » SQL & PL/SQL » Select statements
Select statements [message #206527] Thu, 30 November 2006 07:51 Go to next message
sarah.jones@eds.com
Messages: 2
Registered: June 2006
Location: GB
Junior Member
Sorry if this has been asked before but I'm new.
Please could someone explain what the (+) is for in a select statement?

For example:-
select * from mytable
where column_code (+) = 4

Thanks,
Sarah.
Re: Select statements [message #206529 is a reply to message #206527] Thu, 30 November 2006 07:57 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It does absolutely nothing in this case

(+) is the notation used in Oracle to denote an Outer join, but you need more than one table to have a join.
Re: Select statements [message #206530 is a reply to message #206529] Thu, 30 November 2006 08:02 Go to previous message
sarah.jones@eds.com
Messages: 2
Registered: June 2006
Location: GB
Junior Member
Thanks for your speedy reply.
Previous Topic: 10g pl/sql standard
Next Topic: ORA-24801: illegal parameter value in OCI lob function
Goto Forum:
  


Current Time: Sat Dec 10 01:25:33 CST 2016

Total time taken to generate the page: 0.09222 seconds