Do simple calculation by using dual : DUAL Table « Table « Oracle PL / SQL

1. Oracle PL / SQL
2. Table
3. DUAL Table

Do simple calculation by using dual

    

SQL>
SQL> select 123 * 456 from dual;

   123*456
----------
     56088

SQL>
SQL> select sysdate from dual;

SYSDATE
----------
26-10-2009

SQL>

   
    
    
    
  

Related examples in the same category