Collections:
Define a RECORD Variable for a Table Row in Oracle
How To Define a RECORD Variable to Store a Table Row in Oracle?
✍: FYIcenter.com
If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in the following sample script:
CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL); Table created. CREATE OR REPLACE PROCEDURE FYI_CENTER AS best_student student%ROWTYPE; another_student student%ROWTYPE; 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 ID = ' || best_student.id); DBMS_OUTPUT.PUT_LINE('Best student = ' || best_student.first_name || ' ' || best_student.last_name); END; / Best student ID = Best student = The Best
⇒ Assign a Table Row to RECORD Variable in Oracle
⇐ Define a Data Field as NOT NULL in Oracle
2018-08-14, 1437🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...