1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


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 remove duplicate records from a table?

0 Answers  

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

Why use truncate instead of delete?

0 Answers  

Store procedure will return a value?

4 Answers   eMids,

how do you control the max size of a heap table? : Sql dba

0 Answers  




What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

Where can I learn sql for free?

0 Answers  

Define the select into statement.

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

How do I copy a table in sql?

0 Answers  

What is sql table?

0 Answers  

What is sql used for?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories