BEGIN
SELECT NVL(MAX(TABLE_OWNER || '.' || TABLE_NAME), 'TBLNAME`)
INTO v_table
FROM USER_SYNONYMS
WHERE SYNONYM_NAME = UPPER('TBLNAME') ;
EXCEPTION WHEN OTHERS THEN
v_table := UPPER('TBLNAME');
END;
--
v_sql := 'TRUNCATE TABLE ' || v_table;
EXECUTE IMMEDIATE v_sql;
SELECT NVL(MAX(TABLE_OWNER || '.' || TABLE_NAME), 'TBLNAME`)
INTO v_table
FROM USER_SYNONYMS
WHERE SYNONYM_NAME = UPPER('TBLNAME') ;
EXCEPTION WHEN OTHERS THEN
v_table := UPPER('TBLNAME');
END;
--
v_sql := 'TRUNCATE TABLE ' || v_table;
EXECUTE IMMEDIATE v_sql;