Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Create an Array in PL/SQL
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL
✍: FYIcenter.com
If you want create an array data structure, you can use the collection type VARRAY. VARRAY stands for Variable Array. Here is a sample script on how to use VARRAY:
SQL> set serveroutput on; SQL> DECLARE 2 TYPE list IS VARRAY(3) OF VARCHAR(16); 3 domain_list list; 4 BEGIN 5 domain_list := list('google','fyicenter','myspace'); 6 DBMS_OUTPUT.PUT_LINE('Second domain: ' 7 || domain_list(2)); 8 END; 9 / Second domain: fyicenter
As you can see, to define an array variable, you need to create your own array type, and use that type to define array variables.
2007-04-26, 7008👍, 0💬
Popular Posts:
Write down the equivalent pointer expression for referring the same element a[i][j][k][l]? a[i] == *...
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
Does there exist any other function which can be used to convert an integer or a float to a string? ...
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
Does there exist any other function which can be used to convert an integer or a float to a string? ...