Concatenation operator-data manipulation language, Database Management System

Concatenation operator

Example :

Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES"

FROM EMP;

 

 

Posted Date: 3/11/2013 1:01:11 AM | Location : United States







Related Discussions:- Concatenation operator-data manipulation language, Assignment Help, Ask Question on Concatenation operator-data manipulation language, Get Answer, Expert's Help, Concatenation operator-data manipulation language Discussions

Write discussion on Concatenation operator-data manipulation language
Your posts are moderated
Related Questions
State the process of Rearranging Classes and Operations The various, yet similar operation of different classes can be slightly modified thus that they can be covered by a sin

DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

real life situations where database management system are most suitable

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

#ques 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 p

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

Information about films holds information about movies, stars and studios. Movies have a title, year of production, length and the film type. Stars have a name and address. Studi