Category: Database Development

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

Sep 23 2009

How to insert Blank Line using PLSQL

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