| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP UX 8.1.7 - Urgent
Joshy,
Go to technet.oracle.com You will have to log in, if you don't have an
account, its free to create one.
Click on "Downloads"
Click on "Oracle 8i" (Under the "Archived Products" heading)
I believe it is the last one listed or at least somewhere near the bottom.
>===== Original Message From ORACLE-L_at_fatcity.com =====
>check in oracle technet
>
>-----Original Message-----
>Sent: Saturday, October 19, 2002 10:44 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi All,
>Does anyone of you know where can I download Oracle 8.1.7 for HP-UX from ? I
>searched the net for this, but to no avail.
>Please help
>- Joshy
>
>
>-----Original Message-----
>Sent: Thursday, October 17, 2002 6:34 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: JOSHY MON M C
> INET: JOSHYMON_at_nestec.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ayyappan S
> INET: ayyappan.subramaniyan_at_ssiworldwide.com
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sstefick INET: sstefick_at_harper.cc.il.us 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).Received on Sat Oct 19 2002 - 10:03:39 CDT
 |
 |