Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sqldeveloper 4.0EA1 doesn't support new 12c column default "NOT NULL DEFAULT seq.NEXTVAL"

Uwe SimonJul 26 2013 — edited Jul 29 2013

Caling "Edit" for a table containing a column with the new 12c column default "NOT NULL DEFAULT seq.NEXTVAL"

causes error messagebox

Expression cannot use columns or user functions.  Literal strings should be quoted : "UWE"."TAB_SEQ"."NEXTVAL"

It is not possible to change anything on this table in the "Edit" dialog".

Each click returns the above error message.

The new 12c Identity columns could be edited.

In "Edit Table" dialog the Tab "identify column" does not create any ddl for filling the identity column.Here also only the idenity cloulmn using a trigger is supported, but not the new 12c column default.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2013
Added on Jul 26 2013
5 comments
1,232 views