Write a query that will accept an account no. from the user and debit an amount of 2000 from the account. If account has a min. balance of 500 after the balance is debited. The process is to be fired on the account table
PROGRAM CODE:
DECLARE
acct_balance number(11,2);
acct_no VARCHAR2(6);
debit_amt NUMBER(5) := 2000;
min_bal CONSTANT number(5,2):=500.00;
BEGIN
acct_no := '&acct_no';
SELECT bal into acct_balance
FROM accounts
where account_id=acct_no;
acct_balance:=acct_balance-debit_amt;
IF acct_balance >= min_bal then
....etc

[:=Read Full Message Here=:]

i want an project report on the project bank account tracker ....etc

[:=Read Full Message Here=:]

To get full information or details of create a account in educomp smartclass cts da please have a look on the pages

http://seminarsprojects.net/Thread-create-a-account-in-educomp-smartclass-cts-da?page=10

http://seminarsprojects.net/Thread-create-a-account-in-educomp-smartclass-cts-da?page=9

http://seminarsprojects.net/Thread-create-a-account-in-educomp-smartclass-cts-da?page=7

http://seminarsprojects.net/Thread-create-a-account-in-educomp-smartclass-cts-da?page=6

http://seminarsprojects.net/Thread-create-a-account-in-educomp-smartclass- ....etc

[:=Read Full Message Here=:]

Account Payable System (ACPAYs)
Project Partners:
1.) Mitul Patel (02/CE/61)
2.) Kunal Shah (03/CE/120)

Guide: Mr. Ashwin Makwana


SYNOPSIS

Project Title: Account Payable System (ACPAYs)

Project Definition:
The Account Payable System is designed to provide information to maximize use of other people s money & minimize the clerical efforts required to perform the a/c payable functions.
The system is fully integrated into the FAS & allows input of split distribution of invoices when the pr ....etc

[:=Read Full Message Here=:]

Dear sir/Madem,

please give me the details of how create net Banking process.

Warm Regards
Kanchana.R
[email protected]
Cell No : 8939389260 ....etc

[:=Read Full Message Here=:]

hai

i need some questionnare for asking about the benifit of salary account rendered by sbi banks

thanx ....etc

[:=Read Full Message Here=:]

Hi am Imtiyaz i would like to get details on how to convert my existing sbi savings account to railway salary package account . ....etc

[:=Read Full Message Here=:]

plz tell how to deactivate account on seminarprojects.org!!
ASAP ....etc

[:=Read Full Message Here=:]

I have a DSP account.I have to know about commission of money transfer of Rs.4 lakh to Andhra Bank Account holder.

my E-MAIL : [email protected] ....etc

[:=Read Full Message Here=:]

Introduction to Demat trading account
There are a number of people who do not have the Demat trading accounts, especially in the SBI and IDFC the stream, the number of holders of Demat trading account is not large enough. Many people have no idea about opening the account. This is an important year of account and soon all the people who don't have the Demat trading accounts will be in the lines of the opening because everyone should want to make investments in Politica bond issues.
Let's start with the introduction of Demat trading account, and ....etc

[:=Read Full Message Here=:]