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)
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