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

Write short notes on Schema diagram. A database schema along with primary key and foreign key dependencies can be depicted pictorially by schema diagram. Every relation appears

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and