SELECT 1 FROM DUAL; In Oracle the name of the "fake" is DUAL; T.
On Mar 31, 10:12 am, Dom <dolivas...@gmail.com> wrote: > 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
