1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.

Question Posted / ramkumar

Answers were Sorted based on User's Feedback



have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / kavitha neditunta

select WM_CONCAT(a||','||b)
from tablename;

Is This Answer Correct ?    10 Yes 1 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//text()'),',') single_column
from table_name

Is This Answer Correct ?    5 Yes 0 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / krishna

select rtrim(xmlagg(xmlelement(E,
EMPID||','||NAME||','||'')).extract('//text()') ,',')
empid from emp1

Is This Answer Correct ?    7 Yes 3 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / sunaksha

select listagg( A||','||B || ',') within group (order by A) from table_name;

Is This Answer Correct ?    4 Yes 0 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / saravanan

Try this way!

create table stest(num int,name varchar(10),value numeric
(10,2));

insert into stest values(101,'SARAN',1000.58);
insert into stest values(102,'KALA',1200.18);
insert into stest values(103,'AYYA',3000.40);
insert into stest values(104,'RATNA',4000.57);

SELECT * FROM STEST;

declare @str varchar(2000);
set @str = null;
select @str=ISNULL(@str+',','')+ltrim(STR(num))+','+name
from stest
select @str;

Is This Answer Correct ?    3 Yes 2 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / prativa mishra

select rtrim(xmlagg(xmlelement("c",A||' ,'||B||',')).extract('//test()'),',') single_column
from table_name

Is This Answer Correct ?    1 Yes 0 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / sona mathew

select listagg(c1||','||c2,',')
within group (order by c1||','||c2)
from tab;

Is This Answer Correct ?    1 Yes 0 No

have table with two columns with datatypes as number and varchar and the values in A column like ..

Answer / vi.s.senthilkumar

select column1||','||column2 result from tableName;

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is an implicit commit?

0 Answers  

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

What is the difference between sql and isql*plus?

0 Answers  

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

real time applications of nullif?

3 Answers  




What is rtm in testing?

0 Answers  

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

Explain spool.

0 Answers  

What is the difference between sql, mysql and sql server?

0 Answers  

How do you sort in sql?

0 Answers  

What is a database? Explain

0 Answers  

what is the use of friend function? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories