你即將離開本站

並前往https://gist.github.com/9bbfc9e44e34b3fe1526

Oracle SQL - How to delete all public synonyms for a schema

BEGIN. FOR cur_syn IN (SELECT synonym_name. FROM all_synonyms. WHERE table_owner = 'somebody'). LOOP. BEGIN. EXECUTE IMMEDIATE 'drop public synonym ...

確定！ 回上一頁

查詢 「Delete synonym」的人也找了：

  1. Delete synonym
    2.
  2. Expunge synonym
    3.
  3. Duplicate synonym
    4.
  4. Removing synonym
    5.
  5. Remove synonym
    6.
  6. Eradicate synonym
    7.
  7. Erase synonym
    8.
  8. Add synonym
    9.