Dual in Netezza

When you're used to doing queries in Oracle SQL it can be confusing at times when you start working in Netezza.

While most of the time the syntax is the same, some functions that you're used to using are just not there anymore.

One of them - is dual.

Luckily a quick google on the topic points you straight to the answer. - "_v_dual".

Ie: select sysdate from _v_dual;

Another interesting thing that I recently discovered while working in Netezza is the existence (I'm a really really new user to Netezza) of a spatial module that contains a lot of geo-related functions.

Can't wait to try those out. Will share any stuff that I find soon.

Comments

Popular posts from this blog

HIVE: Both Left and Right Aliases Encountered in Join

Assign select result to variable in Netezza stored procedure

Splitting value in Netezza using array_split