Menu
![]() WHERE eff_dte >= TRUNC (SYSDATE, 'MONTH')ĪND eff_dte < ADD_MONTHS (TRUNC (SYSDATE, 'MONTH'), 1)ĪND dst.exch_from_ctry_cd = src.exch_from_ctry_cd - MaybeĪND dst.exch_to_ctry_cd = src.exch_to_ctry_cd - Maybe PARTITION BY exch_from_ctry_cd, exch_to_ctry_cd - Maybe This sounds like a job for the analytic FIRST_VALUE function: 1.7K Training / Learning / Certification. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |