Re: HP-UX11/Oracle 8.1.6/Constraint Question

I think you should be able to do this through the use of instead of triggers. One for each view, and it would populate the value of :new.device_type before the insert into the base table.

Sorry, no code, just an idea, but I think it will work.

-Mark
On Wed, 2002-10-16 at 20:23, Vergara, Michael (TEM) wrote:
> This is something I'm not sure can be done. Can somebody help
> me out?
>
> I have a single table with a DEVICE_TYPE field, and four views -
> one for each valid device type. DEVICE_TYPE is a NOT NULL field.
> The views are defined like
> create view mytype_vw as
> select col1, col2, col3
> from table
> where device_type = 'MYTYPE';
>
> DEVICE_TYPE is not displayed, it is inferred from the view.
> If I want to insert a row through the view, how can I populate
> the DEVICE_TYPE field?
>
> TIA,
> Mike
>
> ---
> ===========================================================================
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).