Re: How to create aliases for tables

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/02
Message-ID: <01bbf904$4937ce00$1e6893cf@default>#1/1

You need to create SYNONYMS. The syntax for creating public synonyms is

CREATE PUBLIC SYNONYM <synonym_name> FOR <table_name>;

so you need to issue the following command.

CREATE PUBLIC SYNONYM clients FOR sc_customer;

-- 
Vijaya Kumar Vardhineni
Oracle DBA, EDS
Plano, TX

Mirwais Qader <mq_at_wohl.slh.wisc.edu> wrote in article
<32CC2365.6F69_at_wohl.slh.wisc.edu>...


> I would like to create a set of aliases for tables so that

> our users do not have to remember some vague names.

> 

> Example:  I want our "sc_customer" to be "clients"

> 

> Can this be done?  I know in SQL we can do 

> 

> select C.Number

> from   sc_customer C

> where .....

> 

> What I am interested in is a set of "global aliases".

> 

> Please respond with email!

> Thank You!

> -Mir.

>

Received on Thu Jan 02 1997 - 00:00:00 CST