RE: Re: Who are certified Oracle Masters?

t 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 (

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: Mu

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.  

RE: Optimizer Mode......how to choose the right one?

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 -- A

Call Reports built by Report6.0 in Java Applications developed by

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

Report 2.5 or 6 reusable in JDeveloper development ?

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

RE: current transaction in oracle

Y, 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 PROTE

Report 2.5, how to bring up ' 0 ' when sql query returns null ?

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