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
4830 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

How is a PL/SQL code compiled?

1283

What is a natural join sql?

1041

Are stored procedures compiled?

981

What is #table in sql?

1185

Which is better cte or subquery?

1078

Is ms sql is free?

1083

What is where clause in sql?

1088

how many columns can be used for creating index? : Sql dba

989

Is it possible to create the following trigger: before or after update trigger for each row?

1356

what is top in tsql? : Transact sql

1173

What is rownum in sql?

1095

Can we insert data into materialized view?

994

Explain unique key in sql.

1063

Can ddl statements be used in pl/sql?

1195

Explain the savepoint statement.

1140