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
4653 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 the difference between null value, zero, and blank space?

0 Answers

what is sql and plsql

6 Answers

How to assign sql query results to pl sql variables?

0 Answers

What is the Diff b/w Constraints and Trigeer

4 Answers HCL,

What is a record in a database?

0 Answers

How does pl sql work?

0 Answers

What is the relation b/w view and trigger

3 Answers Accenture, TCS,

what is global variable in pl/sql

1 Answers

Differentiate between syntax and runtime errors.

0 Answers

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers TCS,

what are pl/sql collections?

4 Answers JPMorgan Chase, Oracle,

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers

For more SQL PLSQL Interview Questions Click Here