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;
/
Subscribe to:
Post Comments (Atom)
MY HIT COUNTER
Blog Archive
-
▼
2009
(38)
-
▼
November
(27)
- few programs on bank project
- customer identification number
- bank programs
- min balance program in oracle
- cards balance
- real time programs in bank project
- real time registration example
- Creation of tables in oracle
- practice quries
- quries
- reverse number
- throws exception
- throws exception
- divide by zero
- array index
- length of a string name
- no parameters to string
- print two parameters
- abstract class in core java
- inside area of rectangle
- area of rectangle
- three string parameters
- class b extends a
- incremeting numbers
- sum of three parameters
- box program
- strings
-
▼
November
(27)
Custom Search
No comments:
Post a Comment