> The " DUAL " table is a one row and one column table. The owner of this table is "SYS" but it's accessible to all the db users. > It is having single column called as " DUMMY " > It is used to test SQL expression with out querying to the main/real tables. Eg : 1> SELECT SYSDATE FROM DUAL; O.P : It will print current date and time. 2> SELECT 'Hello, Welcome to SQL' from DUAL; O.P : 3> SELECT 5*9 AS RESULT FROM DUAL; O.P: #SQL #LEARNSQL #DUALTABLE
Welcome to our blog for SQL and PLSQL. Here you will find about the SQL basic to advance level things along with PLSQL. Also you will get the latest SQL related Interview questions and answers. I hope you will get the things you are looking for here. Happy learning for SQL and PL-SQL.