Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //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";
- 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