sublime text regexp find multiline text

sql-sublimt-regexp-parse.sql

DROP TABLE "DB"."TABLE";
CREATE TABLE "DB"."TABLE" (
"ID" NUMBER NOT NULL ,
"TITLE" VARCHAR2(100 BYTE) NULL ,
"IMG" VARCHAR2(400 BYTE) NULL ,
"URL" VARCHAR2(400 BYTE) NULL ,
"CRETIME" DATE DEFAULT sysdate  NULL ,
"NUM" NUMBER DEFAULT 0  NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- sublime 多行正则检索, 解析表的创建
-- DROP TABLE((?!NOCACHE\n\n;).|\n)+NOCACHE\n\n;