Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 7936👍, 0💬
Popular Posts:
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...
How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql ...
How To Select Some Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If yo...
What is the version information in XML? “version” tag shows which version of XML is used.
How does ASP.NET maintain state in between subsequent request ? Refer caching chapter.