Collections:
Create an Array in PL/SQL in Oracle
How To Create an Array in PL/SQL in Oracle?
✍: 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.
⇒ Manage Transaction Isolation Levels in Oracle
⇐ Process Query Result in PL/SQL in Oracle
2019-03-08, 2126🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...