LinqConnect Professional Version 4.1.169 (17-Jan-2013) - Oracle DEFAULT value
Posted: Wed 30 Jan 2013 15:59
When update database (Oracle 11g XE) from model, after change field to not null and set default value.
Get this uncorrected script:
Must be like this for Oracle run and don`t show error:
DEFAULT 0 before NOT NULL
Get this uncorrected script:
Code: Select all
ALTER TABLE CEDATABASE."ComSchedules"
MODIFY (
"StartDT" TIMESTAMP,
"FinishDT" TIMESTAMP,
"Priority" NUMBER(3) NOT NULL DEFAULT 0
);
Code: Select all
ALTER TABLE CEDATABASE."ComSchedules"
MODIFY (
"StartDT" TIMESTAMP,
"FinishDT" TIMESTAMP,
"Priority" NUMBER(3) DEFAULT 0 NOT NULL
);