Thanks for the question, Pavan.
Asked: January 22, 2017 - 12:50 pm UTC
Last updated: January 24, 2017 - 9:27 am UTC
Version: Oracle 11g
Viewed 1000+ times
with joined_Result as ( select * from table1 t1 full outer join table2 t2 on ( t1.composite_key_col1 = t2.composite_key_col1 and t1.composite_key_col2 = t2.composite_key_col2 and t1.composite_key_col3 = t2.composite_key_col3 )
with joined_Result as ( select * from table1 t1 full outer join table2 t2 on ( t1.composite_key_col1 = t2.composite_key_col1 and t1.composite_key_col2 = t2.composite_key_col2 and t1.composite_key_col3 = t2.composite_key_col3 ) select * from joined_result where decode(t1.col1,t2.col1,1,0) = 0 or decode(t1.col2,t2.col2,1,0) = 0 or decode(t1.col3,t2.col3,1,0) = 0 ..
A reader, January 24, 2017 - 3:43 am UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!