Make a field have Default Values? (Table Creation)

From: Brian Lavender <blavender_at_spk.usace.army.mil>
Date: Thu, 22 Apr 1999 19:16:03 GMT
Message-ID: <7fnshd$vk$1@nnrp1.dejanews.com>

I am trying to create a table that has a default value in the event the user does not enter a value. I tried this statement for creating the table, but it does not work:

create table test (
id number not null ,
parts number(14,2) default = 0.00
)

How do I make it so parts gets a value of 0.00 if the user does not insert a value?

brian
--
Brian E. Lavender
US Army Corps of Engineers -- Programmer / Systems Analyst Sacramento, CA (916) 557-6623

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 14:16:03 CDT