Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create aliases for tables

Re: How to create aliases for tables

From: Roger Snowden <rsnowden_at_labinterlink.com>
Date: 1997/01/08
Message-ID: <01bbfd81$f304b0c0$096fc589@LHV-06.labinterlink.com>#1/1 







> 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"




Use PUBLIC SYNONYMS.  For example:



CREATE PUBLIC SYNONYM CLIENTS FOR sc_customer;



Works great.



Roger
Received on Wed Jan 08 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US