| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic Column Aliases
"Mike Davis" <cszymans_at_dgroovy.com> a écrit dans le message de
news:Pine.GSO.4.58.0501281646420.27355_at_cpu04.student.cs.uwaterloo.ca...
| Is it possible to have dynamically aliased columns in a select
| statement without using dynamic sql?
|
| I'm wondering if there is a way to do something like the following:
|
|
| SELECT <fieldname> AS <package_name>.<constant> FROM <table>
|
| Thanks in advance.
|
| --Mike
If this is in SQL*Plus you can do something like:
col mycol noprint new_value myalias
set termout off
select <package_name>.<constant> mycol from dual;
set termout on
SELECT <fieldname> AS "&myalias" FROM <table>
Regards
Michel Cadot
Received on Sat Jan 29 2005 - 00:02:05 CST
 |
 |