how to get enames with comma seperated values by deptwise
on emp table?
Answer Posted / pradeep
select deptno,cursor (select ename ,deptno from emp where
d.deptno = deptno ) from dept d
1* select deptno,cursor (select
SQL> /
DEPTNO CURSOR(SELECTENAME,D
---------- --------------------
10 CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
ENAME DEPTNO
---------- ----------
CLARK 10
KING 10
MILLER 10
20 CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
ENAME DEPTNO
---------- ----------
PORT NO 20
SMITH 20
JONES 20
SCOTT 20
ADAMS 20
FORD 20
6 rows selected.
30 CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
ENAME DEPTNO
---------- ----------
ALLEN 30
WARD 30
MARTIN 30
BLAKE 30
TURNER 30
JAMES 30
6 rows selected.
40 CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
no rows selected
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is identity column in sql server?
How do you rename a table in sql?
What is 19 null in sql?
What is the use of sql trace?
How show all rows in sql?
which types of join is used in sql widely? : Sql dba
What is delete command in sql?
What are the different sql languages?
What has stored procedures in sql?
How can get second highest salary in sql?
Is time a data type in sql?
What is a unique constraint?
Why join is faster than subquery?
how would you get the current date in mysql? : Sql dba
What is date functions?