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.
**************************** Scott Stefick UNIX Systems Administrator Oracle Certified DBA Wm. Rainey Harper College Palatine, IL. 60067 847-925-6130 **************************** >===== Original Message From [EMAIL PROTECTED] ===== >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 >[EMAIL PROTECTED] >"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: [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: JOSHY MON M C > 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: Ayyappan S > 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: sstefick 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).