----> There is a table T with two columns C1 and C2. The data

----> There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6

Question Posted / a.brahmam

4 Answers
4883 Views
ICICI, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

----> There is a table T with two columns C1 and C2. The data is as below: ..

Answer / a.brahmam

please i want display the result as :
1 2 3
4 5 6

Is This Answer Correct ?

0 Yes

0 No

----> There is a table T with two columns C1 and C2. The data is as below: ..

Answer / nihar meher

select replace(wm_concat(c1),',',' '),replace(wm_concat(c2),',',' ') from t;

Is This Answer Correct ?

0 Yes

0 No

----> There is a table T with two columns C1 and C2. The data is as below: ..

Answer / ramaraju

select c1 as c1 from t1
union
select c2 as c1 from t1;

try this one.

Is This Answer Correct ?

0 Yes

0 No

----> There is a table T with two columns C1 and C2. The data is as below: ..

Answer / bhanuprakash d

select listagg(c1,' ') within group (order by c1) from T
union
select listagg(c2,' ') within group (order by c2) from T

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the relation b/w view and trigger

3 Answers Accenture, TCS,

Differentiate between pl/sql and sql?

0 Answers

1. how to use the check option constraints in sql query..? 2.how to add data in a complex query ? 3.is it possible to use commit or rollback or savepoint in triggers...if not why please explain with examples...? 4.what is the difference between meterialized view and normal view..how to create materialized view and how to use it..? 5.what is varray...? what is the advantage of the varray ? please expalin with a simpel example..i want to load into a table (student no and name and his marks..) please give example.. 6.what are the bulk bind exceptions...how to use bulk bind and how to use bulk collect..please explain with example... 7.what is for update of and where current of ...? 8 what is the use of nowait ? 9.please give an example for nocopy in a simple plsql query 10.create an index in a table...tellme how to use the index in a where clause to do performance tunning...

3 Answers Satyam,

what is global temporary tables and how use that tables in pl/sql packages

1 Answers Cap Gemini,

Is primary key clustered or nonclustered?

0 Answers

what is a constraint? : Sql dba

0 Answers

What are instead of triggers?

0 Answers

which will default fire first statement level trigger or row level trigger

2 Answers Cap Gemini, Data Vision,

what are all the common sql function? : Sql dba