in Oracle 12c (windows) How do I alter the default definition on a column that is defined as a seque
Hi all,
I need to alter the default value for a column that is defined as a sequence. I thought this command would work, but it is returning the following error. The * is actually under the start of the column name.
sql> alter table ADDRESS modify (record_no number(*,0) default SEQADDRESS.nextval);
alter table ADDRESS modify (record_no number(*,0) default SEQADDRESS.nextval)
*
ERROR at line 1:
ORA-02262: ORA-2289 occurs while type-checking column default value expression
I am running 12.1.0.2 on a Windows 2012 server.
JanV