- This topic has 0 replies, 1 voice, and was last updated 3 weeks, 6 days ago by
.
Viewing 1 post (of 1 total)
-
Posts
-
The dual table is a temporary table which contains exactly one column whose name is dummy and a single row.
In SQL Server, the equivalent of the “dual” table in Oracle is a system table called “sys.dual”. This table contains a single row and a single column, and is often used in SQL queries to perform calculations or return a single result without needing to select from an actual table. You can use it in a similar way to the “dual” table in Oracle.
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.