What does the symbol (+) do in Oracle SQL?

Asked Feb 01 '11 at 20:27

Active Feb 01 '11 at 20:38

Viewed 1,197 times

Possible Duplicates:
What does (+) do in Oracle SQL?
Oracle (Old?) Joins - A tool/script for conversion?

I'm new to SQL, I'm currently taking up SQL fundamentals so please bear with me.. I'm just wondering what the (+) symbol signifies in SQL. please see below:

CREATE VIEW title_avail AS
SELECT t.title, c.copy_id, c.status, r.exp_ret_date
FROM title t, title_copy c, rental r
WHERE t.title_id = c.title_id
AND c.copy_id = r.copy_id(+)
AND c.title_id = r.title_id(+);

edited May 23 '17 at 10:33

Community

asked Feb 01 '11 at 20:27

ace

That operator is specific to Oracle, it is not an SQL standard. See http://stackoverflow.com/questions/1376442/what-does-do-in-oracle-sql – FrustratedWithFormsDesigner Feb 01 '11 at 20:31
And: http://stackoverflow.com/questions/4020786/oracle-operator – OMG Ponies Feb 01 '11 at 20:37
And: http://stackoverflow.com/questions/4001045/how-do-i-convert-a-legacy-left-outer-join-statement-in-oracle – OMG Ponies Feb 01 '11 at 20:38

What does the symbol (+) do in Oracle SQL?

0 Answers0