Assignment II

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

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

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online