Compare columns in a table..

select settings_eil.param_name,  settings_eil.PARAM_VALUE, settings_qa.param_name,  settings_qa.PARAM_VALUE from settings_eil,settings_qa where settings_eil.param_name(+)=settings_qa.param_name order by settings_eil.param_name