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=:]

hi i need ledger account project ....etc

[:=Read Full Message Here=:]

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

[:=Read Full Message Here=:]

pl send me details of home loan intrest rate on sbi dsp account. what emi i have to pay per lakh.
thanking you. ....etc

[:=Read Full Message Here=:]

Abstract:
The “ERP Account for Small Business” has been developed to override the problems prevailing in the practicing manual system. This software is supported to eliminate and in some cases reduce the hardships faced by this existing system. Moreover this system is designed for the particular need of the company to carry out operations in a smooth and effective manner.
The application is reduced as much as possible to avoid errors while entering the data. It also provides error me ....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=:]

how do u delete account from this site and avoid emails from it??
....etc

[:=Read Full Message Here=:]

Project Definition
The project COLLEGE ACCOUNT PACKAGE aims at computerizing the day to day activities of an institution and there by providing secure and reliable storage/access of data. This system is for student’s fee billing, providing college with powerful features for institutions. Designed for ease of use and flexibility, the fee module will save your staff's enormous amount of time in data entry and financial record keeping, it efficiently tracks the details of your past and current fee receipts.
....etc

[:=Read Full Message Here=:]

Guided By :
Amit Patel

Submitted By:
Zinzuvadiya Mansi




Preface

This is to certify that Zinzuvadiya Mansi and Bhimani Dixita has successfully completed his saving account and loan management system on VB-Oracle project work as a part of 5thsemester of B.C.A. During the year 2010 from Shree M.&N. VIRANI SCIENCE COLLEGE, RAJKOT in the development pro ....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 distr ....etc

[:=Read Full Message Here=:]