SQL Language (MOSC)

MOSC Banner

in Oracle 12c (windows) How do I alter the default definition on a column that is defined as a seque

edited Apr 13, 2016 2:28PM in SQL Language (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center