Using column aliases-data manipulation language, Database Management System

Using Column aliases

Example:

To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;

 

 

Posted Date: 3/11/2013 12:59:48 AM | Location : United States







Related Discussions:- Using column aliases-data manipulation language, Assignment Help, Ask Question on Using column aliases-data manipulation language, Get Answer, Expert's Help, Using column aliases-data manipulation language Discussions

Write discussion on Using column aliases-data manipulation language
Your posts are moderated
Related Questions
Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u

comparison of oracle RDBMS with MySQL

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHE

why shadow copy technique is used?


Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

i have assignments I don''t have time to finish because of work and other assignments, can you help with this? All are from the book Darabase design, application development and a