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

Intersection, If R1 and R2 are two union compatible relations or functions,... If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,

Why as clause is used in sql, Why 'AS' clause is used in SQL ? 'As' cla... Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

Differentiate between natural join and outer join, Differentiate between na... Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

Calculate the record size r in bytes, An employee record has the following ... An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];}; (i) Calculate the record size R in bytes.

Assignments, i have assignments I don''t have time to finish because of wo... i have assignments I don''t have time to finish because of work and other assignments, can you help with this? All are from the book Darabase design, application development and a

Enhanced entity relationship, what do you understand by enhanced entity-rel... what do you understand by enhanced entity-relationship

Explain the exec statement in sql, Explain the EXEC statement in SQL  A... Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

What do you understand by raid, What do you understand by RAID? Explain RA... What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

List out user authorization to modify the database schema, List out various... List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

Attribute, composite attribute composite attribute