Hi all...
I am trying to use the WITH clause on Oracle 10g.
when used in following form,
WTH q AS (SELECT * FROM dual)
SELECT * FROM q
it works fine... however, when i want a particular column in following form,
(see the change in BOLD)
WITH q (column1, column2) SELECT * FROM dual)
SELECT * FROM q
it gives error... (this is working fine...