RSS:
Publications
Comments

Category Archives: Database Development

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;
/

How to insert Blank Line using PLSQL

How to insert Blank Line using PLSQL