The table's name is DUAL. Regards, Nirmal -----Original message----- From: Dom Sent: 31/03/2011, 7:42 PM To: Oracle PL/SQL Subject: Is there a null table in SQL I'm just recently moving from SQL_Server to Oracle. In SQL_Server, I can use the statement: " Select 'This is a test' " without a FROM clause. (In practice, I would probably Select a function, as a quick test). In Oracle, this is not allowed, but I seem to remember there is a fake, null, table. For example, " Select 'This is a test' from null ". What is the table name I'm thinking of? -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
-- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
