Collections:
Assign Field Values into RECORD Variables in Oracle
How To Assign Values to Data Fields in RECORD Variables in Oracle?
✍: FYIcenter.com
If a variable is a RECORD variable, you can assign values to its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script assigning values to data fields of RECORD variables:
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 class_name := 'FYI Center 2006'; best_student.first_name := 'The'; best_student.last_name := 'Best'; END; /
⇒ Retrieve Field Values from RECORD Variables in Oracle
⇐ Define a Variable for a Specific RECORD Type in Oracle
2018-09-01, 1324🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...