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
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 ? '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? 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

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.

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

what do you understand by enhanced entity-relationship

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? 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 various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

composite attribute