471,316 Members | 1,217 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

Can I select from a dual table ?

hi,

If I can create a dual table ,then why can't I select from it?
like :select sysdate from dual ?
thanks
sanQUEST
Aug 31 '08 #1
2 4064
amitpatel66
2,367 Expert 2GB
You should be able to select from a dual tbale that you created. What is the error?
Nov 6 '08 #2
Hi,

You can create DUAL table by your own and select sysdate from dual table , but atleast we need to insert 1 value in that dual table.




Regards
Padmanabhan.N
DB2 Associate
Jan 10 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Yaroslav K. Kravchishin | last post: by
3 posts views Thread by Yaroslav K. Kravchishin | last post: by
1 post views Thread by Khurram Rao | last post: by
3 posts views Thread by Arthur | last post: by
13 posts views Thread by James Conrad St.John Foreman | last post: by
5 posts views Thread by Rahul B | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.