I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xy

I have the table like this
S.No Name ID
01 Xyz 123
I want the result as
01Xyz123
How to write the query to retrieve the entire row data in a
single column?

Question Posted / uma

1 Answers
4737 Views
I also Faced
E-Mail Answers

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write t..

Answer / g sivanagaraju

SELECT S.NO||NAME||ID
FROM <table_name>

Is This Answer Correct ?

13 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

How do you run a query?

0 Answers

Define a temp table?

0 Answers

Explain uses of cursor.

1 Answers

What are tuples in sql?

0 Answers

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers

Explain the difference between 'between' & 'and' operators in sql

0 Answers

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers Fidelity, IBM,

What is audit logout in sql profiler?

0 Answers

What are different types of indexes?

0 Answers

what is single byte over head in oracle..?

0 Answers

how will i became good database developer?

1 Answers

Which is better varchar or nvarchar?

0 Answers

For more SQL PLSQL Interview Questions Click Here