Top "Varray" questions

VARRAY (variable-size arrays) is a PL/SQL datatype

PLSQL/ How to add values during iteration of associative array

i need something like this in procedure PLSQL arrayCount:=parArray.Count; For i In 1 .. arrayCount Loop lsPar(i):=parArray(i); …

sql plsql varray
How to add values to a VARRAY using a loop

I have a VARRAY and I want to add elements to this VARRAY by using a loop. This is what …

plsql oracle11g varray
oracle sql varray contains an element

I have a type declaration like this: FUNCTION ... IS TYPE stati_va IS VARRAY (10000) OF varchar(1); stati stati_va; v_…

oracle plsql varray
Difference between NESTED TABLE and VARRAY

I know basic difference and uses of both. But, what I'm looking for as an answer is, why exactly VARRAY …

oracle plsql nested-table varray
PL/SQL use VARRAY in IN CLAUSE

Is it possible to use VARRAY in IN CLAUSE of pl/sql?

oracle plsql oracle10g varray
PL/SQL maximum size of VARRAY

I'm trying to figure out the possible upper bound of VARRAY in PL/SQL. We sure can define VARRAY type …

oracle plsql size database-administration varray
How to initialize a varray table of {TABLE}%ROWTYPE?

I have a varray defined like: declare TYPE tnr_l IS VARRAY(30) of lve%ROWTYPE; I want this varray to …

oracle plsql initialization ora-06550 varray
Pass varray variables into stored procedure - basic

Hello I am a php developer, trying to get going with Oracle. So I need to pass a collection of …

oracle stored-procedures collections plsql varray
How to Select value in Oracle Varray

Working in Oracle 11.2 I have created a type for phone numbers to be associated with an employee.... I'm trying to …

sql oracle varray