RE: Linking to a SQL Server

2003-11-26 Thread Thompson, Todd
or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy copies of the original message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thompson, Todd INET: [EMAIL PROTECTED] Fat City Network

Multiple Instances and 9iRAC

2003-03-14 Thread Thompson, Todd
My company is currently considering using Oracle 9i RAC. One of the proposed environments is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC cluster. Does anyone have any insights as to the viability of this implementation? Will the high speed inter connect be

RE: Multiple Instances and 9iRAC

2003-03-14 Thread Thompson, Todd
channels as interconnect; but for HP clusters you will lean towards CLIC interface. The environment you mentioned is not just viable, but that's exactly how it isdone. HTH. Arup Nanda - Original Message - From: Thompson, Todd To: Multiple

RE: How to document a DB

2003-03-10 Thread Thompson, Todd
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.net -- Author: Thompson, Todd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Function to round to the nearest 15

2002-03-26 Thread Thompson, Todd
- De: Thompson, Todd [mailto:[EMAIL PROTECTED]] Date: lundi 25 mars 2002 16:23 À: Multiple recipients of list ORACLE-L Objet: Function to round to the nearest 15 Fichier: ATT250969.ATT I'm trying to convert a minutes field to hours

Function to round to the nearest 15

2002-03-25 Thread Thompson, Todd
I'm trying to convert a minutes field to hours and fractional hours. I need the fractional hours portion rounded to the nearest quarter hour... any SQL (no PLSQL) suggestions would be helpful. 1=.25 48=.75 90=1.5 95=1.5 98=1.75 application/ms-tnef

RE: Template for documenting database

2002-01-07 Thread Thompson, Todd
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thompson, Todd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

CODE to trap an update statement in PL*SQL that updates 0 rows

2001-08-09 Thread Thompson, Todd
%5324Y'5$A%(E)%5%523DE. M1TE.5$\B0TP``@%_``$```!`/#)%139!-3`W,D)%0T0T,3$Y0D8X M,#!!,$,Y04(R03@R-C0W-$90'9IS`P,2YB8VAAG)IW!U8BYC;VT^`/PR ` end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thompson, Todd INET: [EMAIL PROTECTED] Fat City Network Services-- (858

SQL Query to combine multiple rows into 1 ?

2001-05-18 Thread Thompson, Todd
!U8BYC;VT^ #`-$Y ` end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thompson, Todd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists