dynamically assign column headers

[sonuji_in]

Hi

is there any way to dynamically assign column headers in a SQL

statement?

Select col_1||' '||col_2 dynamic_name from table where x = y
and have the dynamic_name be derived from another table?
thanks
Sonu Saxnea

[sonuji_in]

ya friends i got the solution
DB817>col ename new_value name
DB817>select ename from emp where empno = 7369;

ENAME
----------
SMITH

DB817>col dummy head &name
DB817>select ename dummy from emp;

sonu saxena