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




      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