Wednesday, June 23, 2010

(+) On Which Side

I've always got confused on which side to put the (+) sign while doing a join.

Example:
select stmt_run_id, q.id from t_stmt_run_date ,(select 2893 id from dual )q
where  q.id(+)=stmt_run_id;

This will display all the rows from t_stmt_run_date, so here's my mechanism for the (+) sign , put the (+) sign on the side that might not contain the value.The (+) acts like a shot of medicine to help display it's values.

Can you put a (+) sign on both sides?
 The answer is no.The query will fail.

No comments:

Post a Comment