I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xy

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

1 Answers
4671 Views
I also Faced
E-Mail Answers

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

What is normalization? dec 2009

3 Answers Cognizant,

Difference between global and parameter variables?

0 Answers TCS,

How do you exit in sql?

0 Answers

How does pl sql work?

0 Answers

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers

What is the file extension for sql database?

0 Answers

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers Reliance,

what is the difference between the query and corelated query

8 Answers HSBC, IBM, TCS, Xenosoft,

using comand prompt how can import table data and table space with example

2 Answers

What is a parameter query?

0 Answers

What sql does db2 use?

0 Answers

For more SQL PLSQL Interview Questions Click Here