Re: How to create aliases for tables

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/04
Message-ID: <32CE83C6.6AE1@qrcsun.qrc.org>#1/1

Mirwais Qader wrote:
>
> 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"

CREATE PUBLIC SYNONYM clients FOR sc_customer. (If sc_customer is not owned by the creator, use CREATE PUBLIC SYNONYM clients FOR table_owner.sc_customer, where table_owner is the name of the owner).

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Sat Jan 04 1997 - 00:00:00 CST