Top "Dual-table" questions

The DUAL table is a special one-row, one-column table.

What is the dual table in Oracle?

I've heard people referring to this table and was not sure what it was about.

oracle dual-table
What is the equivalent of the Oracle "Dual" table in MS SqlServer?

What is the equivalent of the Oracle "Dual" table in MS SqlServer? This is my Select: SELECT pCliente, 'xxx.x.…

sql-server oracle dual-table
pseudo columns & DUAL table - what do they actually mean?

Dual table is used to select pseudo columns. it has one row and one column DUMMY which has a value …

sql oracle dual-table
Oracle select from dual with multiple rows and columns

I need to join against a dynamic list of numbers that I retrieve from my program dynamically. The number of …

oracle dual-table
SQL (Oracle) Select without an actual table containing static data

I am looking for a possibility to run an (Oracle) SQL without querying an actual table. Here I found a …

sql oracle dual-table
What is Teradata's equivalent for Oracle's DUAL

In Oracle, we can write this to generate a single row using a SELECT statement. SELECT 1 AS x FROM dual …

sql teradata dual-table