Synonyms, Database Management System

Synonyms It allows short names or alternative names for objects.

Example:

              CREATE SYNONYM D30

              FOR EMPD30;

  Now if we give command:

             SELECT * FROM D30;

NAME

MINSAL

MAXSAL

AVGSAL

---------------------

------------

-------------

--------------

ACCOUNTING

1300

5000

2916.6667

RESEARCH

800

3000

2175

SALES

950

2850

1566.6667

 

Posted Date: 3/11/2013 2:33:00 AM | Location : United States







Related Discussions:- Synonyms, Assignment Help, Ask Question on Synonyms, Get Answer, Expert's Help, Synonyms Discussions

Write discussion on Synonyms
Your posts are moderated
Related Questions
One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con

What are two special events? The two special events are as "entry" and "exit". Any action which is marked as linked to entry event is executed whenever given state is entered v

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo


Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.


Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap

Express the properties of Strings? Strings can be case sensitive (or not) which can change the outcome of string operations. You can evaluate whole strings \ just part

what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin