I know that (+) is used in outer joins to include the row as null if there is no matching record. But I find - (minus) operator also. Could someone tell me what it is used for ? Is the opposite of the (+) used for outer join ?
( I was executing my code after commenting using -- . I removed the comments and found no results. I found that the comment was not removed properly; I removed only one of - instead both. The query works fine but I would like to know what is the use of '-' operator.)