Collections:
Define a Specific RECORD Type in Oracle
How To Define a Specific RECORD Type in Oracle?
✍: FYIcenter.com
If you want to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration part of any procedure or function. The following example script defines a RECORD type called STUDENT:
CREATE OR REPLACE PROCEDURE HELLO AS TYPE student IS RECORD ( id NUMBER(5), first_name VARCHAR(80), last_name VARCHAR(80) ); BEGIN NULL; END; /
⇒ Define a Variable for a Specific RECORD Type in Oracle
⇐ What Is a RECORD in PL/SQL in Oracle
2018-09-01, 1450🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...