0 Replies Latest reply on Aug 1, 2016 8:35 AM by GregV

    Query result displays an empty column for an expression doing simple arithmetics

    GregV

      Hi,

       

      The following query against v$asm_disk displays nothing for the expression I called "used_gb":

       

      select total_mb, free_mb, total_mb-free_mb used_mb,(total_mb-free_mb)/1024 used_gb
      from v$asm_disk;
      

       

      Screen Shot 08-01-16 at 10.29 AM.PNG

      If I run it as a script (F5), it shows something

      Screen Shot 08-01-16 at 10.31 AM.PNG

       

      Is there any setting I can adjust? I'm using version 4.1.3.20.

       

      Thanks