-
Hi, all
I tried to modify a column which would have sysdate as the default value, it worked as I enter:
alter table xxx
modify(created default sysdate);
But when I tried to modify a column so that it would accept the current login user as a default value, it didn't work.
This column has a datatype and size varchar2(16). I entered:
alter table xxx
modify(createdby default USER);
I'm getting an error:
ORA-01401 Inserted value too large for column.
So what's the right way to do it?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|