SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release  10 . 2 . 0 . 1 . 0  - Prod
PL/SQL Release  10 . 2 . 0 . 1 . 0  - Production
CORE	 10 . 2 . 0 . 1 . 0 	Production

TNS for  32 -bit Windows: Version  10 . 2 . 0 . 1 . 0  - Production
NLSRTL Version  10 . 2 . 0 . 1 . 0  - Production

SQL> select statistic# from v$statname sn where sn.NAME='table scan rows gotten';

STATISTIC#
----------
        249 

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        201 

SQL> select * from dual;

DUMMY
-----
X

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        202 

SQL> select  1  from dual;

          1 
----------
          1 

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        202 

SQL> select sysdate from dual;

SYSDATE
-----------
 11 . 02 . 2006 

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        202 

SQL> select (select sysdate from dual) from dual;

(SELECTSYSDATEFROMDUAL)
-----------------------
 11 . 02 . 2006   18 : 09 : 01 

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        202 

SQL> select * from dual;

DUMMY
-----
X

SQL> select value from v$mystat st where st.STATISTIC#= 249 ;

     VALUE
----------
        203