Mega Code Archive

 

Categories / Oracle PLSQL / 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>