OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Re: Default value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Default value [message #370219]

Mon, 14 December 1998 17:03

Bruce
Messages: 21
Registered: November 1998

Junior Member

Yes.

Report message to a moderator

Re: Default value [message #370220 is a reply to message #370219]

Mon, 14 December 1998 17:29

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??

Report message to a moderator

Re: Default value [message #370221 is a reply to message #370220]

Tue, 15 December 1998 12:48

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...

Report message to a moderator

Re: Default value [message #370223 is a reply to message #370221]

Thu, 04 February 1999 01:13

D.manoharan
Messages: 1
Registered: February 1999

Junior Member

Mr.May,
can you give example for that.

Report message to a moderator

Previous Topic:	alternate use of NOT IN
Next Topic:	Re: Help oracle time fomatting is driving me crazy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:06:50 CDT 2024