Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> VAR : does anybody have a clue?
This is what I am trying to do:
SQL> var x number -- declare a variable named x
Now, what I want to do is assign:
select sum(bytes) from v$sgastat INTO x
to be used as follows:
SELECT name, bytes, bytes/x FROM v$sgastat;
bytes/x would give me the percent of the sga devoted to that particular sga component in the third column.
Does anybody know the CORRECT way to do this?
Thanks
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 12 1999 - 15:50:17 CST