ASSIGNMENT-composite data types

ASSIGNMENT-composite data types - to the table some values...

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

View Full Document Right Arrow Icon
ASSIGNMENT COMPOSITE DATA TYEPS 1. Write a PL/SQL block to load the employee names and salaries into plsql table and then display the contents of the table 2. Declare a record type to hold empno and ename . Declare a plsql table of this record type. Display the values of empno and ename(use emp table) 3. Declare a PLSQL block, which holds information about student’s marks. Add and
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to the table some values and display. 4. Create an abstract data type of students personal information in the database. Declare a plsql table of this abstract type. Populate the plsql table and display information....
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