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

Ask an Expert

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

Write your message here..

Related Questions

Non-redundant cover and canonical cover, Given the following set of functio... Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Log based recovery, under what condition log based recovery is feasible? under what condition log based recovery is feasible?

Mapping, external and internal mapping with examples external and internal mapping with examples

Linked list, what is difference between circular inked lust and grunded lin... what is difference between circular inked lust and grunded linked list

DEADLOCK PREVENTION, WOUND-WAIT WOUND-WAIT

Mapping Constraints, what is Mapping Constraints? with examples what is Mapping Constraints? with examples

Write the sql code, Express the following queries in SQL: (a) Write the... Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

What is the use of with clause in sql, What is the use of with clause in SQ... What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

Types of fragmentation, vertical fragmentation vertical fragmentation

Two types of blocks in the fixed -length representation, What are the two t... What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha