SELECT S.NO||NAME||ID FROM <table

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 / g sivanagaraju

1 Answers
4735 Views
I also Faced
E-Mail Answers

Answer Posted / g sivanagaraju

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

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a primary key? : Sql dba

1029

What is set serveroutput on?

1129

How can you load microsoft excel data into oracle? : aql loader

1173

Are null values same as that of zero or a blank space?

1023

What is aggregate function in sql?

1031

How do I remove all records from a table?

1069

Is grant a ddl statement?

894

what is sub-query? : Transact sql

1095

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1216

What is the difference between inner join and outer join?

989

What are the disadvantages of not performing database normalization?

1155

Which data type is a composite type?

986

What type of join is sql join?

978

How can we make an if statement within a select statement?

1007

What is auto increment?

995