Nov 12 2009

How to Use Records in PL/SQL

We can use Records in PL/SQL
DECLARE

TYPE Fdr_rec_type IS RECORD
(Name VARCHAR2(25),
Age NUMBER,
Salary NUMBER);

recFeeder Fdr_rec_type;

BEGIN
select ‘Mudhalvan’,25,4500 INTO recFeeder from dual;

END;
/

Comments are closed.

Alibi3col theme by Themocracy