RE: Re: Who are certified Oracle Masters?
high 300K to 0.5M for a townhouse and 500K to 1M for single house -Original Message- Sent: Wednesday, December 17, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Bethesda city center on Wisconsin Av.? Nice place with some rather fancy restaurants around. I drove around Washington and Bethesda and I must say that it is a beautiful area. I would like to live in Reston, VA. Did you know that propery prices in Reston are comparable to those on LI? On 12/17/2003 11:04:29 AM, Rachel Carmichael wrote: > I ended up going to Bethesda from NYC to take the class with him > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > I've taken those for 8i. Scott is a great guy and the course is > > excellent. > > In NYC there was a waiting list for his course. > > On 12/17/2003 09:19:26 AM, "Boivin, Patrice J" wrote: > > > So we have to take two advanced Oracle courses... > > > > > > I have a bad feeling that the Oracle Internals Seminars by Scott > > Gossett > > > don't count. > > > > > > Would that be correct? They are not part of the OCP tracks. > > > > > > Patrice. > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Boivin, Patrice J > > > 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). > > > > > > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > 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). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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.net -- Author: Hsu, Anthony C., ,CPMS 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).
RE: Table Size
Try:
SELECT segment_type,
segment_name,BLOCKS*8192/1024 "Kb"
FROM DBA_SEGMENTS
WHERE OWNER=UPPER('') AND SEGMENT_NAME =
UPPER('');
Tony
-Original
Message-From: Pillai, Rajesh
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15,
2003 3:24 PMTo: Multiple recipients of list
ORACLE-LSubject: Table Size
Hi
All,
Could somebody help me in
finding the actual size of an oracle table in GB.
TIA,
Rajesh
RE: Modify init.ora
In 9i, a new parameter file called SPFILE is introduced. A SPFILE enable you to self-tune the parameter values that are recorded in the file. You can use ALTER SYSTEM parameter = value [ SCOPE=MEMORY|SPFILE|BOTH] command to change the values of the dynamic instance parameters. Thanks. Anthony -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 10:18 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Modify init.ora INIT.ORA is looked up at the time of STARTUP only. PROCESSES cannot be changed until the DB is bounced. To see whether a particular parameter can be modified without bouncing the DB query the V$PARAMETER view Regards Naveen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 08, 2002 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: Modify init.ora Hi! DBAs, If I modify the "Process" in init.ora after database was created and running for quite a long while, is it true that the maximum of the process will increase as what i changed? do i need to change anything? init.ora will be used everytime the database start, right? or just for the initialization for db creation? thanks in advance.
RE: Optimizer Mode......how to choose the right one?
formation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hsu, Anthony C., ,CPMS 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-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).
Call Reports built by Report6.0 in Java Applications developed by
Hi, I am wondering if someone knows or has experience to reuse existing old Report 2.5 or 6.0 in Java applications developed by using Jdeveloper ? Can we just simply call the old reports without rebuild them in Java development ? Any info will be helpful. Thanks. Tony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hsu, Anthony C., ,CPMS 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-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).
Report 2.5 or 6 reusable in JDeveloper development ?
Hi, I am wondering if someone knows or has experience to reuse old Report 2.5 or 6 in Java applications developed by using Jdeveloper ? Can we just simply call the old reports without rebuild them in Java development ? Any info will be helpful. Thanks. Tony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hsu, Anthony C., ,CPMS 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-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).
RE: current transaction in oracle
Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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-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: Hsu, Anthony C., ,CPMS 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-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).
Report 2.5, how to bring up ' 0 ' when sql query returns null ?
Hi friends, I would appreciate that if anyone can share the idea to bring up ' 0' after SQL query returns null in Report 2.5 ? What I mean is in Report 2.5, if I have four SQL queries and each query will returns each quarterly data and I need to display ' 0' even though there is no records return for the 2nd quarter. My report now can display data like below and the SQL query is /* select count(rain_days), count(sunshine_days) from weather where quarter='2' */ and the return is null quarter qtr1qtr3qtr4 rain days # 20 15 25 sunshine days# 10 15 5 I want to have report can display like below even though my SQL query /*select count(rain_days), count(sunshine_days) from weather where quarter='2'*/ returns null quarter qtr1qtr2qtr3qtr4 rain days # 20 0 15 25 sunshine days# 10 0 15 5 Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hsu, Anthony C., ,CPMS 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-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).
