Collections:
Retrieve Field Values from RECORD Variables in Oracle
How To Retrieve Values from Data Fields in RECORD Variables in Oracle?
✍: FYIcenter.com
If a variable is a RECORD variable with data fields assigned values, you can retrieve those values out of its data fields by using fields names prefixed with variable name as "variable.field_name". Here is a sample script showing you how to retrieve field values from 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'; DBMS_OUTPUT.PUT_LINE('Best student = ' || best_student.first_name || ' ' || best_student.last_name); END; / Best student = The Best
2018-09-01, 690👍, 0💬
Popular Posts:
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...