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, 1449🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...