Re: Dynamic Column Aliases

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?

What would stop me is that the aliased name is meaningless and I rarely see any value in AS ... except when creating a view or cursor based on the use of a function.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)