Select Query in Select List

[jmodic]

Originally posted by stecal
I should have been clearer - the way the question was posed, without any where clause that restricts the output, would not and does not work.

Sure it does! Or you should have been clearer again . Here is an example with no WHERE clause anywhere:

SQL> select dname, (select dummy from dual) from dept;

DNAME          (
-------------- -
ACCOUNTING     X
RESEARCH       X
SALES          X
OPERATIONS     X

SQL>