77 457
Assignments Done
98,9%
Successfully Done
In July 2019

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

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

Not answered

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 first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions