OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number

Re: Re[2]: OCP Question (Perf Tuning)

2004-01-06 Thread Jay Wade
PROTECTED] and include the word subscribe in either the subject or body. MG On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent

Simple SQL Question

2003-12-18 Thread Jay Wade
A.emp=B.Emp(+) and A.emp=C.Emp(+) _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET

IOT Tuning Question

2003-11-20 Thread Jay Wade
_ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET

10g: SQL Plus

2003-09-22 Thread Jay Wade
_ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED

RE: Oracle Script Documentation

2003-09-05 Thread Jay Wade
-- Author: Jay Wade 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

Re: ODP.NET and LONG RAW

2003-08-29 Thread Jay Wade
your children with advanced parental controls. http://join.msn.com/?page=features/parental -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OCP Question

2003-08-14 Thread Jay Wade
service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

More On 10G

2003-08-04 Thread Jay Wade
_ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: How to display FLOAT in 99999.999 format

2003-08-01 Thread Jay Wade
: Jay Wade 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

Re: ORA-03115 (TOAD question!!)

2003-07-29 Thread Jay Wade
Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)

2003-07-16 Thread Jay Wade
mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: SQL question - crosstab in oracle

2003-07-08 Thread Jay Wade
command for other information (like subscribing). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay

Re: erwin

2003-07-07 Thread Jay Wade
*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle Book Clubs/Lists?

2003-06-23 Thread Jay Wade
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

8i OCP Question

2003-06-17 Thread Jay Wade
in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED

Re: RE: 8i OCP Question

2003-06-17 Thread Jay Wade
/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8i OCP Question

2003-06-17 Thread Jay Wade
is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i

RE: example to use bind variables with OO4O/VB

2003-06-06 Thread Jay Wade
information (like subscribing). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL

RE: Using bind variables with ADO in VB

2003-06-06 Thread Jay Wade
). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OCP Test Order

2003-06-03 Thread Jay Wade
? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL

Re: Recommendations

2003-06-03 Thread Jay Wade
-- Author: Jay Wade 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

Re: AW: From Microsoft Access to Oracle

2003-03-18 Thread Jay Wade
your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Question On High Parse to execute ratio

2003-01-13 Thread Jay Wade
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Flat file generation integrity ideas...

2002-10-27 Thread Jay Wade
(like subscribing). _ Internet access plans that fit your lifestyle -- join MSN. http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL

RE: PL/SQL Editor

2002-08-28 Thread Jay Wade
and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Explain Plan Question

2002-08-12 Thread Jay Wade
not seem to be included in the Plan Output. Is this correct? Regards, Jay _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET

RE: set sql*trace VB/Crystal

2002-08-12 Thread Jay Wade
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Portal Question

2002-07-25 Thread Jay Wade
with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-25 Thread Jay Wade
’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Q: How to Find Cursor Size

2002-07-24 Thread Jay Wade
is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

OT: Job Locations

2002-07-09 Thread Jay Wade
-- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

Re: download leads to sales call

2002-07-08 Thread Jay Wade
FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re:RE: Alternative to Crystal Reports

2002-06-20 Thread Jay Wade
). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: So, What is a 'Production DBA'?

2002-05-30 Thread Jay Wade
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Jr.DBA, Mid level DBA, Sr.DBA

2002-05-30 Thread Jay Wade
_ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: How to find current ORACLE_HOME programmatically

2002-05-22 Thread Jay Wade
-- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E

OT: Using Java Blocks Can Anyone Help?

2002-01-28 Thread Jay Wade
hello:Can you run a Java Store Procedure as an anonymous block? I'm trying to doas suggested and use Java to delete an operating system file (Win2k/NT).The only issue is that this must be executed in script format withoutstoring any objects or references in the database. Since I am using

Re: Using Java Blocks Can Anyone Help?

2002-01-28 Thread Jay Wade
, the procedure are not executed correctly. - Original Message - From: Jay Wade To: Multiple recipients of list ORACLE-L Sent: Monday, January 28, 2002 1:55 PM Subject: OT: Using Java Blocks Can Anyone Help? hello: Can you run a Java Store Procedure as an anonymous

Re: TOAD Login Problem

2002-01-26 Thread Jay Wade
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Moving Files Around

2002-01-24 Thread Jay Wade
Hello: I have read and tried (sorry newbie) the procedures involved with moving control files, database files, etc. But I have never seen any reference to how to move the instance reference to the parameter file. Whenever had to move a db I've always done at least some exp/imp. I was

Re: Database Views

2002-01-20 Thread Jay Wade
: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself