Search This Blog

2016/12/26

Delete data by using synonym in Oracle

Code:
DELETE FROM syn_table_name;

Attention
User have delete authority.

Why don't use truncate?
As Synonyms can't be used in drop table/view or truncate table/cluster statements. It will cause ORA-00942: table or view does not exist.

No comments :

Post a Comment