AllTypesEgNestPLVARRAY

AllTypesEgNestPLVARRAY - FOR i IN v1.FIRST . . v1.LAST LOOP

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

View Full Document Right Arrow Icon
Sheet1 Page 1 set serveroutput on DECLARE TYPE nested_type IS TABLE OF VARCHAR2(20) TYPE varray_type IS VARRAY(5) OF INTEGER TYPE associative_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER v1 nested_type v2 varray_type v3 associative_array_type begin v1:=nested_type ('aaa','bbb','ccc') dbms_output.put_line('nested types--'||v1(1)||v1(2)||v1(3)) --This example shows how to reference an element in the nested table v1
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: FOR i IN v1.FIRST . . v1.LAST LOOP dbms_output.put_line(v1(i)) END LOOP--This example shows how to reference an element in the varray v2:=varray_type(1,2,3,4,5) FOR i IN v2.FIRST . . v2.LAST LOOP dbms_output.put_line(v2(i)) END LOOP--plsql table v3(1):=22 v3(2):=33 v3(3):=55 v3(45):=66 v3(-1):=90 end...
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