DUAL is an internal Oracle table consisting of a single field and a single row. It is used as a "dummy" table for issuing SQL statements. In SQL Server, the equivalent is to omit the From clause (select 1, "Happy")
Adam Dorritie *(pronounced just like Daugherty)* Daniel Daugherty <[EMAIL PROTECTED]> asks > One question for you is > "DUAL" a real table with no records or a Oracle special statement? ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
