Hi,

I am creating a table and want to make the default to ('user')but it's not working if you know the right syntax, let me know. If you can help, that would be just greaaat!!! Thanks Peter.

Example:

create table region (
name varcha2(14),
date_created Date Default (Sysdate) not null,
modified_by varchar2(30) Default (user) not null
)