| synonymns [message #374308] |
Tue, 05 June 2001 07:55  |
theresia
Messages: 9
Registered: May 2001
|
Junior Member |
|
|
i would like to known what is the use of
synonymns.when is it neccessary to create
synonymns?
thanks
sini
|
|
|
|
| Re: synonymns [message #374312 is a reply to message #374308] |
Tue, 05 June 2001 08:10  |
Cindy
Messages: 88
Registered: November 1999
|
Member |
|
|
-- simplify access to objects by creating a synonym (another name for an object).
-- refer to a table owned by another user
-- shorten lengthy object names, such as views.
Guidelines:
-- the object can not be contained in a package
-- a private synonym name must be unique from all other objects owned by the same user
For more information, see Oracle Server SQL Reference, Release 8, "CREATE SYNONYM"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
