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
What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

a set of possible data value of an attribute is called??

What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand

Problem 1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples 2 Explain the following performance tuning techn

Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem