DUAL

MySQL

Example

SELECT 'Hello, World!' FROM DUAL;

Output

+---------------+
| Hello, World! |
+---------------+
| Hello, World! |
+---------------+

Explanation

The DUAL is a special one-row, one-column table present by default in MySQL and other databases. In the example, we selected a string ‘Hello, World!’ from the DUAL table. As DUAL only contains one row and one column, a single value will be returned.

Oracle

Example

SELECT 'Hello, World!' FROM DUAL;

Output

'Hello, World!'

Explanation

The DUAL is a one-row, one-column table present by default in Oracle and other database installations. In this example, the DUAL table is utilized to select a static text string. The result is a single row with a single column that contains the string ‘Hello, World!’.