select ename ||' , '||deptno from emp order by deptno

how to get enames with comma seperated values by deptwise
on emp table?

Question Posted / rasmita basantia

Answer Posted / rasmita basantia

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between rename and alias?

1025

What is the size of partition table?

1056

Does asenumerable execute the query?

1056

What are the different schemas objects that can be created using pl/sql?

1042

What is nosql vs sql?

1183

What is a field in a database?

1073

Why do we need cursor in pl sql?

1142

How long does it take to learn pl sql?

1077

Is sql a oracle?

986

Which join is like inner join?

1046

What is asqueryable?

988

Why schema is used in sql?

1060

What are the types of triggers in sql?

1100

Define commit, rollback and savepoint?

1040

What are tables and fields?

1048