Use of DUAL Table in Oracle Database Example

How to Use DUAL Table in Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to use dual table in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR

   SELECT * FROM DUAL;
   -- Arithmetic on dual table
   SELECT 2+2 FROM DUAL;
   -- character literal string on dual table
   SELECT 'Nothing' FROM DUAL;
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How to Use DUAL Table in Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..