Hi to all,
I created following table
-------------------------------------------------------------------
create table interiors(id integer, name varchar(20), type varchar(20) default 'baby cot', price integer)
--------------------------------------------------------------------
but, when i doesn't inserted any value of 'type', by the definition of table, it should take default value. when i fetch all rows by 'select' query, it doesn't show default value.
can anyone tell me that what is the problem?
Thanks & regards,
Pooja.