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
Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t

Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger

Normal 0 false false false EN-US X-NONE X-NONE

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea

Represent the following scenarios with E-R diagrams drawn using the ER Assistant software. The diagrams should indicate cardinality and optionality of relationships. Transform each

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider