SELECTING FROM DUAL : DUAL Table « Table « Oracle PL / SQL

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

SELECTING FROM DUAL

  

SQL>
SQL> DESC DUAL;
 Name                                                                                                                                    Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------
 DUMMY                                                                                                                                            VARCHAR2(1)

SQL> SELECT * FROM DUAL;

D
-
X

1 row selected.

SQL>
SQL> SELECT 18*1.05 FROM DUAL;

   18*1.05
----------
      18.9

1 row selected.

SQL>
SQL> select 'ABC' from dual;

'AB
---
ABC

1 row selected.

SQL>
SQL> select 'A' || 'B' from dual;

'A
--
AB

1 row selected.

SQL>

   
  

Related examples in the same category