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, 1424🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...