Home » RDBMS Server » Server Administration » Re: Default value
Re: Default value [message #370219] Mon, 14 December 1998 17:03 Go to next message
Bruce
Messages: 21
Registered: November 1998
Junior Member
Yes.
Re: Default value [message #370220 is a reply to message #370219] Mon, 14 December 1998 17:29 Go to previous messageGo to next message
Rupali
Messages: 1
Registered: December 1998
Junior Member
Altered the table via
alter table radio modify dfm float(38) default 99.0;

now when i try to enter a record thru my software and leave the entry blank for dfm, it should save the record with a dfm value of 99.0 instead of 0 but it doesnt do that. It saves the record with a value of 0. why??
Re: Default value [message #370221 is a reply to message #370220] Tue, 15 December 1998 12:48 Go to previous messageGo to next message
May
Messages: 5
Registered: December 1998
Junior Member
Once you specified default value for that column then no need to specify anything for that. But if you include column for which you specified default value then you have to specify some value for that column (in case you are using forms) becuse form builts SQL statment based on property of fields.

In shot if you want to store default value specified in column don;t use that column in SQL statement but default value can not be used for the purpose you mentioned. To store 99.0 instead of 0. For this you might have to use DECODE.

Bye...
Re: Default value [message #370223 is a reply to message #370221] Thu, 04 February 1999 01:13 Go to previous message
D.manoharan
Messages: 1
Registered: February 1999
Junior Member
Mr.May,
can you give example for that.
Previous Topic: alternate use of NOT IN
Next Topic: Re: Help oracle time fomatting is driving me crazy
Goto Forum:
  


Current Time: Sun Oct 25 08:52:22 CDT 2020