Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
|
CREATE OR REPLACE PROCEDURE transfer( crdtacno IN NUMBER, dbtacno IN NUMBER, amount NUMBER, transno NUMBER ) IS BEGIN INSERT INTO transaction VALUES(transno,amount,SYSDATE); UPDATE account SET accbal=accbal+amount WHERE accno=crdtacno; INSERT INTO entrylist VALUES(transno,crdtacno,'CR'); UPDATE account SET accbal=accbal-amount WHERE accno=dbtacno; INSERT INTO entrylist VALUES(transno,dbtacno,'DB'); END; / 
|