Answer to Question #20613 in Databases | SQL | Oracle | MS Access for Devika

Question #20613
I have two tables
1.emp(eno,ename,dno,.......)
2.dept(dno,dname,loc)

I want to write a pl/sql block to display all dname and all corresponding employee names(ename) using single cursor.

eg: dname: accounting
mark
patrick

dname: research
mohan
adams

.................
.............
0
Expert's answer

Answer in progress...

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
APPROVED BY CLIENTS