Hi experts I'm trying to create a table by using Jdeveloper sql editor , copied this code while executing got the error like this. I'm not getting what is error here.
Error starting at line : 1 in command -
create table XXTG_ECOM_OMS_HEADERS_ALL2(
OMS_HEADER_ID NUMBER(2) NOT NULL
,VENDOR_NAME VARCHAR2(100) NOT NULL
,BATCH_NUMBER VARCHAR2(100)
,BATCH_MSG_COUNT NUMBER(3)
,BATCH_FILE_DATE DATE NOT NULL
,CUSTOMER_NUMBER VARCHAR2(20) NOT NULL
,WAREHOUSE_CODE VARCHAR2(10)
,ORG_ID NUMBER NOT NULL
,VENDOR_PO_NUMBER VARCHAR2(50) NOT NULL
,VENDOR_ORDER_NUMBER VARCHAR2(50) NOT NULL
,VENDOR_ORDER_ID VARCHAR2(30)
,ORDER_LINE_COUNT NUMBER(2)
,ORDER_NOTE1 VARCHAR2(1000)
,ORDER_NOTE2 VARCHAR2(1000)
,ORDER_NOTE3 VARCHAR2(1000)
,ORDER_NOTE4 VARCHAR2(1000)
,ORDER_GIFT_INDICATOR VARCHAR2(10)
,ORDER_GIFT_MESSAGE VARCHAR2(1000)
,ORDER_VENDOR_MESSAGE VARCHAR2(1000)
,OMS_CONFIRMATION_STATUS VARCHAR2(50)
,ORDER_STATUS_CODE VARCHAR2(50) NOT NULL
,ORDER_FRAUD_STATUS_CODE VARCHAR2(50) NOT NULL
,ORDER_FRAUD_LEVEL VARCHAR2(50) NOT NULL
,ORACLE_FLAG VARCHAR2(1)
,ASN_FLAG VARCHAR2(1)
,PAYMENT_PROCESSED_FLAG VARCHAR2(1)
,FRAUD_EMAIL_FLAG VARCHAR2(1)
,FRAUD_EMAIL_FLAG_DATE DATE
,FRAUD_SCORE NUMBER(6)
,TMX_ORDER_NUMBER NUMBER
,TMX_HEADER_ID NUMBER
,ORDER_FULFILLMENT_FEE NUMBER(7,2)
,ORDER_PAYMENT_METHOD VARCHAR2(250)
,CUSTOMER_ORDER_DATE DATE NOT NULL
,VENDOR_ORDER_DATE DATE
,REQUESTED_SHIP_BY_DATE DATE
,REQUESTED_ARRIVAL_DATE DATE
,REQUESTED_ORDER_CANCEL_DATE DATE
,OMS_SHIPPING_PRICE NUMBER(7,2)
,OMS_SHIPPING_TAX NUMBER(7,2)
,OMS_SHIPPING_GROSS_PRICE NUMBER(7,2)
,OMS_SHIPPING_BASE_PRICE NUMBER(7,2)
,OMS_SHIPPING_ITEM_TEXT VARCHAR2(250)
,OMS_SHIPPING_TAX_BASIS NUMBER(7,2)
,OMS_SHIPPING_NET_PRICE_ADJ NUMBER(7,2)
,OMS_SHIPPING_TAX_ADJ NUMBER(7,2)
,OMS_SHIPPING_GROSS_PRICE_ADJ NUMBER(7,2)
,OMS_SHIPPING_BASE_PRICE_ADJ NUMBER(7,2)
,OMS_SHIPPING_TAX_BASIS_ADJ NUMBER(7,2)
,OMS_SHIPPING_ITEM_TEXT_ADJ VARCHAR2(250)
,OMS_SHIPPING_PROMOTION_ID VARCHAR2(250)
,OMS_SHIPPING_COMPAIGN_ID VARCHAR2(250)
,OMS_SHIPPING_COUPON_ID VARCHAR2(250)
,OMS_SHIPPING_ITEM_ID VARCHAR2(250)
,OMS_SHIPPING_TAX_RATE NUMBER(7,2)
,OMS_MER_TOTAL_VAL NUMBER(7,2)
,OMS_MER_TOTAL_TAX NUMBER(7,2)
,OMS_MER_TOTAL_GROSS NUMBER(7,2)
,OMS_MER_ADJ_TOTAL_VAL NUMBER(7,2)
,OMS_MER_ADJ_TOTAL_TAX NUMBER(7,2)
,OMS_MER_ADJ_TOTAL_GROSS NUMBER(7,2)
,OMS_SHIP_TOTAL_VAL NUMBER(7,2)
,OMS_SHIP_TOTAL_TAX NUMBER(7,2)
,OMS_SHIP_TOTAL_GROSS NUMBER(7,2)
,OMS_SHIP_ADJ_TOTAL_VAL NUMBER(7,2)
,OMS_SHIP_ADJ_TOTAL_TAX NUMBER(7,2)
,OMS_SHIP_ADJ_TOTAL_GROSS NUMBER(7,2)
,OMS_ORDER_NET_TOTAL NUMBER(7,2)
,OMS_ORDER_TAX_TOTAL NUMBER(7,2)
,OMS_ORDER_TOTAL NUMBER(7,2)
,ORDER_TOTAL_PRICE NUMBER(7,2)
,ORDER_TOTAL_COST NUMBER(7,2)
,ORDER_TOTAL NUMBER(7,2)
,ORDER_BALANCE_DUE NUMBER(7,2)
,CURRENCY VARCHAR2(20)
,ORDER_TAX_VALUE NUMBER(7,2)
,ORDER_TAX_TYPE VARCHAR2(200)
,ORDER_PROMOTION_VALUE NUMBER(7,2)
,ORDER_PROMOTION_TYPE VARCHAR2(100)
,ORDER_SHIPPING_AMOUNT NUMBER(7,2)
,ORDER_SHIPPING_TAX_VALUE NUMBER(7,2)
,ORDER_SHIPPING_TAX_TYPE VARCHAR2(100)
,ORDER_SHIPPING_PROMOTION_VALUE NUMBER(7,2)
,ORDER_SHIPPING_PROMOTION_TYPE VARCHAR2(100)
,TMX_FREIGHT_TERM_CODE VARCHAR2(30)
,VENDOR_SHIPPING_METHOD_CODE VARCHAR2(50)
,ORDER_PACK_LIST_MSG VARCHAR2(1000)
,SHIP_FIRST_NAME VARCHAR2(150)NOT NULL
,SHIP_MIDDLE_NAME VARCHAR2(60)
,SHIP_LAST_NAME VARCHAR2(150) NOT NULL
,SHIP_COMPANY_NAME VARCHAR2(100)
,SHIP_ADDRESS1 VARCHAR2(240) NOT NULL
,SHIP_ADDRESS2 VARCHAR2(240)
,SHIP_ADDRESS3 VARCHAR2(240)
,SHIP_CITY VARCHAR2(60) NOT NULL
,SHIP_STATE VARCHAR2(60) NOT NULL
,SHIP_COUNTY VARCHAR2(20)
,SHIP_COUNTRY VARCHAR2(60) NOT NULL
,SHIP_POSTAL_CODE VARCHAR2(60)
,SHIP_POSTAL_CODE_EXT VARCHAR2(20)
,SHIP_EMAIL VARCHAR2(2000) NOT NULL
,SHIP_DAY_PHONE VARCHAR2(40)
,SHIP_NIGHT_PHONE VARCHAR2(40)
,SHIP_RECEIPT_ID VARCHAR2(50)
,OMS_CUSTOMER_NUMBER VARCHAR2(150)
,OMS_CUSTOMER_NAME VARCHAR2(150)
,BILL_FIRST_NAME VARCHAR2(150) NOT NULL
,BILL_MIDDLE_NAME VARCHAR2(60)
,BILL_LAST_NAME NOT NULL VARCHAR2(150) NOT NULL
,BILL_COMPANY_NAME VARCHAR2(100)
,BILL_ADDRESS1 VARCHAR2(240) NOT NULL
,BILL_ADDRESS2 VARCHAR2(240)
,BILL_ADDRESS3 VARCHAR2(240)
,BILL_CITY VARCHAR2(60) NOT NULL
,BILL_STATE VARCHAR2(60) NOT NULL
,BILL_COUNTY VARCHAR2(20)
,BILL_COUNTRY VARCHAR2(60) NOT NULL
,BILL_POSTAL_CODE VARCHAR2(60)
,BILL_POSTAL_CODE_EXT VARCHAR2(20)
,BILL_EMAIL NOT NULL VARCHAR2(2000)
,BILL_DAY_PHONE VARCHAR2(40)
,BILL_NIGHT_PHONE VARCHAR2(40)
,OMS_ORDER_ORIG_CAPTURE_PRICE NUMBER(7,2)
,OMS_ORDER_ORIG_CAPTURE_TAX NUMBER(7,2)
,OMS_ORDER_ORIG_CAPTURE_SHIP NUMBER(7,2)
,OMS_ORDER_ORIG_CAPTURE_TOTAL NUMBER(7,2)
,CONTEXT VARCHAR2(30)
,ATTRIBUTE1 VARCHAR2(240)
,ATTRIBUTE2 VARCHAR2(240)
,ATTRIBUTE3 VARCHAR2(240)
,ATTRIBUTE4 VARCHAR2(240)
,ATTRIBUTE5 VARCHAR2(240)
,ATTRIBUTE6 VARCHAR2(240)
,ATTRIBUTE7 VARCHAR2(240)
,ATTRIBUTE8 VARCHAR2(240)
,ATTRIBUTE9 VARCHAR2(240)
,ATTRIBUTE10 VARCHAR2(240)
,ATTRIBUTE11 VARCHAR2(240)
,ATTRIBUTE12 VARCHAR2(240)
,ATTRIBUTE13 VARCHAR2(240)
,ATTRIBUTE14 VARCHAR2(240)
,ATTRIBUTE15 VARCHAR2(240)
,ATTRIBUTE16 VARCHAR2(240)
,ATTRIBUTE17 VARCHAR2(240)
,ATTRIBUTE18 VARCHAR2(240)
,ATTRIBUTE19 VARCHAR2(240)
,ATTRIBUTE20 VARCHAR2(240)
,CREATED_BY VARCHAR2(50) NOT NULL
,CREATION_DATE DATE NOT NULL
,LAST_UPDATED_BY VARCHAR2(50) NOT NULL
,LAST_UPDATE_DATE DATE NOT NULL
,PAYMENT_CARD_TYPE VARCHAR2(240)
,PAYMENT_CARD_TOKEN VARCHAR2(240) NOT NULL
,PAYMENT_CARD_HOLDER VARCHAR2(240)
,PAYMENT_EXP_MONTH VARCHAR2(240)
,PAYMENT_EXP_YEAR VARCHAR2(240)
,PAYMENT_AMOUNT VARCHAR2(240) NOT NULL
,PAYMENT_TRX_ID VARCHAR2(240) NOT NULL
,PAYMENT_PROCESSOR_ID VARCHAR2(240)
,PAYMENT_TRX_TYPE VARCHAR2(240)
,PAYMENT_BUSINESS_TYPE VARCHAR2(240)
)
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action: