Hi our oracle developer is out for the rest of the week and i need to convert a sql server query to an oracle query. Any help would be greatly appreciated.
update stg_property set tag_fama_score = pa.tag_fama_score, cat_fama_score_color = pa.cat_fama_score_color from stg_property p inner join oe_mf_data_mart..mf_loan_perf_quartly_panel Pa on p.pk_property_id = pa.fk_property_id and --Bring back Maximum Year Pa.fk_fiscal_year = (select max(qp0.fk_fiscal_year) FROM oe_mf_data_mart..mf_loan_perf_quartly_panel qp0 WHERE qp0.fk_fha_number = pa.fk_fha_number ) --Bring back Maximum Quarter AND Pa.fk_fiscal_quarter = (select max(qp1.fk_fiscal_quarter) FROM oe_mf_data_mart..mf_loan_perf_quartly_panel qp1 WHERE qp1.fk_fha_number = pa.fk_fha_number )
They're not that different. I suspect the trouble you'll have is here: oe_mf_data_mart..mf_loan_perf_quartly_panel which is looking at a different database. There is no direct comparison here, you will have to check your own implementation for this part. If it were me I'd be using a linked table. Take a look at the dependencies on that table and see if you can find a previously convered example. Nobody outside your organisation will be able to help you with that I'm afraid. The rest of it should just work.