Collections:
Define a Variable for a Specific RECORD Type in Oracle
How To Define a Variable of a Specific RECORD Type in Oracle?
✍: FYIcenter.com
Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defined with a regular data type and a specific RECORD type:
CREATE OR REPLACE PROCEDURE HELLO AS TYPE student IS RECORD ( id NUMBER(5), first_name VARCHAR(80), last_name VARCHAR(80) ); best_student student; another_student student; class_name VARCHAR2(80); BEGIN NULL; END; /
⇒ Assign Field Values into RECORD Variables in Oracle
⇐ Define a Specific RECORD Type in Oracle
2018-09-01, 1445🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...