customer identification number

create or replace procedure abovelakh5064 as
cursor c1 is select * from customer_master5064 where balance>100000;
t customer_master5064%rowtype;
begin
open c1;
dbms_output.put_line('');
if (c1%rowcount<=0) then
dbms_output.put_line('No Customers Available Balance Above 100000');

end if;
loop
fetch c1 into t;
exit when c1%notfound;
dbms_output.put_line('Customer Identification Number: '||t.cin ||'Customer Number: '||t.accno ||'Customer Name: '||t.custname ||'Account Opening Date: '|| t.opdate || 'Opening Balance: '||t.opbal|| 'Balance : '||t.balance);

end loop;
dbms_output.put_line('');
close c1;
end;
/

No comments:

Post a Comment

Template Design by faris vio