Advertisement
Guest User

Untitled

a guest
Jan 20th, 2020
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. //String runTableSQL = "SELECT NVL(TABLE_NAME,'"+tableSynonym+"') FROM "+targetSchema+".ODP_ETL_TABLE_PART_STATE WHERE TABLE_NAME LIKE '"+tableSynonym+"%' AND NVL(LAST_UPDATE_DATE_START,TO_DATE('2005-01-01','YYYY-MM-DD')) = (SELECT MIN(NVL(LAST_UPDATE_DATE_START,TO_DATE('2005-01-01','YYYY-MM-DD'))) FROM "+targetSchema+".ODP_ETL_TABLE_PART_STATE WHERE TABLE_NAME LIKE '"+tableSynonym+"%') ORDER BY 1";
  2. String runTableSQL = "SELECT DECODE(table_name, synonym_name, table_name||'_2', synonym_name) FROM ALL_SYNONYMS WHERE synonym_name in ('"+tableSynonym+"');"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement