--Step1、Query Data SELECT FDS.DB_SEQUENCE_NAME, FDS.DOC_SEQUENCE_ID, FDS.NAME FROM FND_DOCUMENT_SEQUENCES FDS WHERE 1 = 1 AND FDS.NAME = 'Want to Delete Data' --Use Step1 DB_SEQUENCE_NAME DROP SEQUENCE APPLSYS.XXXX; --其餘省略 --Use Step1 DOC_SEQUENCE_ID DELETE FND_DOC_SEQUENCE_ASSIGNMENTS FDSA WHERE FDSA.DOC_SEQUENCE_ID = XXXX --Use Step1 NAME DELETE FND_DOCUMENT_SEQUENCES A WHERE 1 = 1 AND A.NAME = 'XXXX'
沒有留言:
張貼留言