Select Query in Select List

[pando]

it depends what do you want to do

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 8 22:21:30 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> select ename, (select dname from dept where deptno = 10) dname
  2  from emp
  3  where deptno = 10;

ENAME      DNAME
---------- --------------
CLARK      ACCOUNTING
KING       ACCOUNTING
MILLER     ACCOUNTING



SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 8 22:21:15 2002

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

lsc@DEV817>select ename, (select dname from dept where deptno = 10) dname
  2  from emp
  3  where deptno = 10;

ENAME      DNAME
---------- --------------
CLARK      ACCOUNTING
KING       ACCOUNTING
MILLER     ACCOUNTING