Re: Make a field have Default Values? (Table Creation)

VERY CLOSE! Try

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

Patrick Suppes

Brian Lavender wrote:

> 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:50:33 CDT