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, 1746🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...