I'm getting error when I try to create a table with USER as
i.e create table test (col1 varchar2(18) default USER);
ERROR at line 1:
ORA-01401: inserted value too large for column
if I expand col1 to varchar2(30) then I won't have this problem. Does this means the length of USER is 30?
Can anyone confirm that the default size for USER is 30.
Usernames can be from 1 to 30 characters long, size of col1 must be at least 30 and there is reason to make it larger.
Click Here to Expand Forum to Full Width