Mike Davis wrote:
> On Fri, 28 Jan 2005, DA Morgan wrote:
>
>
>>Mike Davis wrote:
>>
>>
>>>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 you concatenate strings together what would stop you?
>
>
> Nothing. However, my question was if there was away to do it without
> dynamic sql. I would really like to avoid the overhead of parsing,
> execution path optimization, etc. at runtime.
>
> --Mike
Michel gave you an answer good if you are in SQL*Plus but in PL/SQL
you must concatenate it in.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Jan 29 2005 - 11:55:59 CST
