Hello! I wrote: create table dog( dogID integer, dname varchar2(10), dschool varchar2(10) default 'ss', ); The whole table was empty. When I tried to insert values, I got value for school the one I wrote in insert into statement, so I never got 'ss' for school. Please, is it possible at all to do in oracle and how? http://www.w3schools.com/sql/sql_default.asp Many thanks!!!