Assignment II

Assignment II - be displayed 3 Use s cursor to retrieve the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment – Cursors 1. Create script to create a new table(top_dogs) for storing employees and their salaries name varchar2(25), salary number(15,2) 2. Create a PL/SQL block that determine the top employees with respect to salaries ( n value should be accepted by user and that many record should
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: be displayed ) 3. Use s cursor to retrieve the department number and department name from the dept table . Pass the department number to another cursor to retrieve from the emp table the details of employee name , job, hiredate , and salary of all the employees who work in that department...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online