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
Is trigger a stored procedure?
Can instead of triggers be used to fire once for each statement on a view?
What is a constraint?
What is rank () in sql?
What are the properties of a transaction?
What is memory optimized table?
What is %type in sql?
Which nosql database is best?
Is record in oracle pl sql?
what are the advantages of using stored procedures? : Sql dba
What is record type in pl sql?
Explain the commit statement.
what is bdb (berkeleydb)? : Sql dba
What is loop in pl sql?
What is sql used for?