SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dummy table in Oracle

586717Jul 6 2007 — edited Jul 6 2007

We have a dummy table in oracle named dual which has a single row and a single column. We can use this dual table to retrieve output of any single row functions.
But the size of that single column is just 1 char. when we execute

select sysdate from dual;

how it retrieves system date which is more than one char?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2007

Added on Jul 6 2007

5 comments

8,519 views