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
What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien


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

List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac

In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined