RE: SQL+ need help (low priority)

From: Harsh Agrawal <HARSHA_at_Amdocs.com>
Date: Thu, 23 Aug 2001 03:23:53 -0700
Message-ID: <F001.00374C5D.20010823034129@fatcity.com>

It seems that the column format of col. VALUE is less.

Before giving the first command give the following command

column value

It will display the current column format of column "VALUE"

Now second SELECT doesn't gives any problem 'coz col format is assigned on col. VALUE not on VALUE + 0.

Just run the following SELECT

select name,value + 0 VALUE from v$sga;

It will also give the same prob.

So bottom line is prblm with column format.

Hope it helps.

Thanks
Harsh

-----Original Message-----
Sent: Thursday, August 23, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L

Hi all,

When I do

Select * from v_$sga;

NAME                              VALUE
--------------------------- -----------
Fixed Size                          ###########
Variable Size               ###########
Database Buffers                    ###########
Redo Buffers                ###########

Select name, value + 0 from v_$sga;

NAME                              VALUE
--------------------------- -----------
Fixed Size                                  69616
Variable Size                  16089088
Database Buffers                       38010880
Redo Buffers                     180224

Do you know what happen with the ####

Thank You

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinardy
INET: sinardyxing_at_bcsis.com

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: ListGuru_at_fatcity.com (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: Harsh Agrawal
INET: HARSHA_at_Amdocs.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------