Using literal character string-data manipulation language, Database Management System

Using Literal Character String

Example:

To print IS A as one string with column name employee

SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;

 

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







Related Discussions:- Using literal character string-data manipulation language, Assignment Help, Ask Question on Using literal character string-data manipulation language, Get Answer, Expert's Help, Using literal character string-data manipulation language Discussions

Write discussion on Using literal character string-data manipulation language
Your posts are moderated
Related Questions
Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

What are the properties of transaction? There are three properties of transactions :- A)     Atomicity B)      Consistency C)       Isolation

WHAT IS MEANT BY E-R MODEL

Define Atom of domain relational calculus An atom has the outline 1 , x 2 , ... , x n > -> r , in which r stands for a relation on n attributes and x 1 , x 2 , ... , x n ar