Re: Dynamic Column Aliases

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 Received on Fri Jan 28 2005 - 21:06:33 CST