Can I select from a dual table ?

[sanQUEST]

hi,

If I can create a dual table ,then why can't I select from it?
like :select sysdate from dual ?
thanks
sanQUEST

[amitpatel66]

You should be able to select from a dual tbale that you created. What is the error?

[ganeshmn25]

You can Create dual table and select it

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