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
4741 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 function and procedure?

1031

Which command is used to delete a package?

1173

What is the difference between union and union all command?

1088

Explain spool.

1179

what are the 'mysql' command line options? : Sql dba

1072

Is full outer join same as cross join?

969

What is the difference between clustered and non-clustered indexes?

1092

What is sql*loader?

1189

What is difference between joins and union?

1124

how to create a new view in mysql? : Sql dba

935

How many aggregate functions are available there in sql?

983

Why is pl sql used?

980

what is error ora-03113: end-of-file on communication channel?

1165

What is normalization in sql?

1012

What is loop in pl sql?

1037