Re: alias for an oracle field

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Jul 2005 01:20:33 +0200
Message-ID: <21k8d1llimo029a6ratqtan34jq4v2f8qj@4ax.com>

On 12 Jul 2005 15:09:02 -0700, "mike" <hillmw_at_charter.net> wrote:

>I have an oracle table and the names of the fields are a little
>mis-leading for the average user.
>
>I'd like to show the user an alias and when the user chooses the alias,
>then I'd like to use that field in the query.
>
>For example there is a field called "sp_id" and I'd like the user to
>see "site_process"
>
>Then I'd like to use "select site_process .... from ..." in my query.
>
>I've never used an alias before or if it's possible

Did you hear of views? You need to create a view on top of the original table.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jul 12 2005 - 18:20:33 CDT