Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
(?<=CONTRAINT)(.*)(?="ACCOUNT_ID")
/
Input 1
CREATE TABLE "SALES"."ACCOUNT_" ( "ORGANIZATION_ID" CHAR(15) NOT NULL ENABLE, "ACCOUNT_ID" CHAR(15) NOT NULL ENABLE, "DIVISION" NUMBER NOT NULL ENABLE, "OWNER" CHAR(15) NOT NULL ENABLE, "DELETED" CHAR(1) DEFAULT '0' NOT NULL ENABLE, "PARENT_ID" CHAR(15) NOT NULL ENABLE, "CURRENCY_ISO_CODE" CHAR(3) NOT NULL ENABLE, "SUPPRESS_TERRITORY_RULES" CHAR(1) DEFAULT '0' NOT NULL ENABLE, "SYSTEM_MODSTAMP" DATE DEFAULT SYSDATE NOT NULL ENABLE, "LAST_UPDATE" DATE DEFAULT SYSDATE NOT NULL ENABLE, "CREATED_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE, "CREATED_BY" CHAR(15) NOT NULL ENABLE, "LAST_UPDATE_BY" CHAR(15) NOT NULL ENABLE, "PERSON_CONTACT_ID" CHAR(15) NOT NULL ENABLE, "SHORT_DESCRIPTION" VARCHAR2(4000), "RECORD_TYPE_ID" CHAR(15), "LAST_ACTIVITY" DATE, "SS_ENABLED" CHAR(1), "SS_LAST_LOGIN" DATE, "ACCOUNT_NUMBER" VARCHAR2(120), "NAME" VARCHAR2(765), "NAME_LOCAL" VARCHAR2(765), "PHONE1" VARCHAR2(120), "PHONE2" VARCHAR2(120), "ADDRESS1_STREET"
Substitution
CREATE TABLE "SALES"."ACCOUNT_" ( "ORGANIZATION_ID" CHAR(15) NOT NULL ENABLE, "ACCOUNT_ID" CHAR(15) NOT NULL ENABLE, "DIVISION" NUMBER NOT NULL ENABLE, "OWNER" CHAR(15) NOT NULL ENABLE, "DELETED" CHAR(1) DEFAULT '0' NOT NULL ENABLE, "PARENT_ID" CHAR(15) NOT NULL ENABLE, "CURRENCY_ISO_CODE" CHAR(3) NOT NULL ENABLE, "SUPPRESS_TERRITORY_RULES" CHAR(1) DEFAULT '0' NOT NULL ENABLE, "SYSTEM_MODSTAMP" DATE DEFAULT SYSDATE NOT NULL ENABLE, "LAST_UPDATE" DATE DEFAULT SYSDATE NOT NULL ENABLE, "CREATED_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE, "CREATED_BY" CHAR(15) NOT NULL ENABLE, "LAST_UPDATE_BY" CHAR(15) NOT NULL ENABLE, "PERSON_CONTACT_ID" CHAR(15) NOT NULL ENABLE, "SHORT_DESCRIPTION" VARCHAR2(4000), "RECORD_TYPE_ID" CHAR(15), "LAST_ACTIVITY" DATE, "SS_ENABLED" CHAR(1), "SS_LAST_LOGIN" DATE, "ACCOUNT_NUMBER" VARCHAR2(120), "NAME" VARCHAR2(765), "NAME_LOCAL" VARCHAR2(765), "PHONE1" VARCHAR2(120), "PHONE2" VARCHAR2(120), "ADDRESS1_STREET"