Monday, December 5, 2011

Oracle DUAL equivalent in Netezza

There is a view named _v_dual in Netezza that can be used to replace Oralce's Dummy DUAL Table.

For ex.,
In Oracle:
select sysdate from dual;

In Netezza:
select current_date from _v_dual;

(Please note also that there is no sysdate in Netezza)

No comments:

Post a Comment