2023-07-04|閱讀時間 ‧ 約 1 分鐘

ORACLE: SYNONYM

~~~ 從 Xuite 搬過來 ~~~
-- CREATE SYNONYM
CREATE [OR REPLACE]  [PUBLIC] SYNONYM  synonym  FOR  object;
-- sample...
CREATE OR REPLACE PUBLIC SYNONYM VW_FFUTURESACCOUNT_SUM_NAME
FOR FSMS.VW_FFUTURESACCOUNT_SUM_NAME;

-- DELETE SYNONYM
DROP [PUBLIC]  SYNONYM synonym
-- sample...
DROP PUBLIC SYNONYM VW_FFUTURESACCOUNT_SUM_NAME;
分享至
成為作者繼續創作的動力吧!
© 2024 vocus All rights reserved.