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