Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Make a field have Default Values? (Table Creation)

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

From: Peter L <news_at_lenniep.freeserve.co.uk>
Date: Thu, 22 Apr 1999 22:01:19 +0100
Message-ID: <7fo71u$19h$2@news7.svr.pol.co.uk>


An on_insert trigger on table test could be used to add the default value.

Brian Lavender wrote in message <7fnshd$vk$1_at_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.
>How do I make it so parts gets a value of 0.00 if the user does not insert
a
>value?
Received on Thu Apr 22 1999 - 16:01:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US