DUAL is a DUMMY table.
DUAL table is one-row, one-column table present by default in Oracle.
In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'.
It is suitable for use in selecting a pseudo column such as SYSDATE or USER
DUAL table is one-row, one-column table present by default in Oracle.
In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'.
It is suitable for use in selecting a pseudo column such as SYSDATE or USER
No comments:
Post a Comment