Interested to Buy Any Domain ? << Click Here >> for more details...
how to get enames with comma seperated values by deptwise
on emp table?
- 8 Answers
- 11858 Views
- I also Faced
- E-Mail Answers
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
Which is better trigger or stored procedure?
What is clustered index sql?
Which query operators in sql is used for pattern matching?
Is clustered index a primary key?
What happens when a trigger is associated to a view?
What does cursor do in sql?
What is the difference between function and procedure in pl/sql?
What is dbo in sql?
What is meant by cursor in sql?
What is dense_rank?
Is sqlexception checked or unchecked?
What is the usage of distinct keyword?
How does a trigger work?
Why do we use sqlite?
What are the differences between implicit and explicit cursors?
