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
- 12079 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
what is the difference between union and union all? : Sql dba
How do I count rows in sql query?
Write an sql query to select all records from the table?
What is the use of function in sql?
Does sql view stored data?
What is pessimistic concurrency control? : Transact sql
How to call shell script from pl sql procedure?
What are the disadvantages of file system?
what is 'mysqldump'? : Sql dba
What is offset in sql query?
Does sql support programming?
Are views faster than queries?
What is the difference between the conventional and direct path loads? : aql loader
How do you break a loop in pl sql?
What is sql select statement?
