Clear a veriable &&Bytes

[AJCG]

Hi,

I have written the smallest sql query in the world just to give me file size, but once I have defined &&bytes every time I run in again I am unable to redifine it?

select sum(&&Bytes/1024/1024) from dual;
Enter value for bytes: 65945600

SUM(65945600/1024/1024)
-----------------------
62.890625

VIRGIN_OWNER@>@bytes

SUM(65945600/1024/1024)
-----------------------
62.890625

How do I clear this?

Thanks

Adam

 

[stefanhei]

Hi
UNDEFINE bytes before your select should solve.

Stefan

 

[AJCG]

Thanks that worked!!!

I feel stupid!