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
4713 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 compute?

1072

Mention what are different methods to trace the pl/sql code?

1178

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

Why use triggers in sql?

931

How do I create a sql script?

1085

Is pl sql still used?

961

what is the different between now() and current_date()? : Sql dba

994

Which certification is best for sql?

974

What are data types in pl sql?

1126

What type of join is sql join?

963

Define select, insert, create, delete, update, drop keywords

1035

What is the main reason behind using an index?

1001

What is dbo in sql?

941

Why are sql stored procedures used?

1043

Explain the update statement in sql

971