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

use of IN/ANY/ALL

5 Answers   Ramco,

what are the security recommendations while using mysql? : Sql dba

0 Answers  

Can you join a table to itself?

0 Answers  

What are sql commands?

0 Answers  

Which is better join or subquery?

0 Answers  




Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

Is a secondary key the same as a foreign key?

0 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

How do I find duplicates in the same column?

0 Answers  

How do you get column names only for a table (sql server)?

0 Answers  

How do you delete data from a table?

0 Answers  

How do temporal tables work?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories