Answer to Question #20613 in Databases | SQL | Oracle | MS Access for Devika
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
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
Leave a comment