A "BEFORE INSERT" trigger would work. Use it to set the value of the field.
-----Original Message-----
Sent: Thursday, October 17, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
Mike,
Try using an 'instead of' trigger. It's made to purpose.
Dick Goulet
____________________Reply Separator____________________
Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]>
Date: 10/16/2002 4:23 PM
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
