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

How is a PL/SQL code compiled?

1172

Is sql sequential or random?

983

when is the use of update_statistics command? : Sql dba

972

What is sql mysql pl sql oracle?

1028

List out the acid properties and explain?

905

What are the 3 modes of parameter?

1103

What is secondary key?

882

what is a field in a database ? : Sql dba

991

What are the two types of exceptions.

1108

What is the process of debugging?

1006

What is a call statement? Explain with an example.

953

What are inbuilt functions in sql?

992

Does a user_objects view have an entry for a trigger?

963

Which join is like inner join?

978

What are the uses of sysdate and user keywords?

1053