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;
/
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;
/
SQL> set serveroutput on size 1000000
SQL> begin
2 dbms_output.put_line(‘this is a line’);
3 dbms_output.put_line(chr(9));
4 dbms_output.put_line(‘another line’);
5 end;
SQL> /
this is a line
another line
Alibi3col theme by
Themocracy