Simple Database Trigger in Oracle- Part 1

create table AccountHolders(
ID VARCHAR2(4 BYTE) NOT NULL,
UserName VARCHAR2(10 BYTE),
AccountID VARCHAR2(10 BYTE),
CellPhoneNumber VARCHAR2(10 BYTE),
TotalAmount VARCHAR2(10BYTE)
)



insert into AccountHolders(ID, UserName, AccountID, CellPhoneNumber,TotalAmount)
values ('01','Rossi','001','+880172','2334' )



CREATE TABLE mytriggertable( event VARCHAR2(400) )

create or replace trigger mytrigger
BEFORE INSERT OR UPDATE OR DELETE ON AccountHolders
DECLARE
mymessage varchar2(200) ;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
IF inserting THEN
mymessage := ' Insert into AccountHolders @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
ELSIF updating THEN
mymessage := ' Update of employee @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
ELSIF deleting THEN
mymessage := ' Delete of employee @ ' || to_char(sysdate, 'mm/dd/yyyy hh:mi') || ' by ' || user ;
END IF;
INSERT INTO mytriggertable VALUES(mymessage);
COMMIT;
END;



insert into AccountHolders(ID, UserName, AccountID, CellPhoneNumber,TotalAmount)
values ('02','Bapin','003','+880167','1334' )

Scrum

http://www.codeproject.com/KB/architecture/scrum.aspx

Sourceforge Tips

http://osdir.com/ml/linux.hams/2003-05/msg00059.html
http://alexandria.wiki.sourceforge.net/Subversion+Client+-+Command-line+SVN+client#top

Yahoo Antivirus

http://techiecorner.blogspot.com/2006/10/yahoo-messenger-virus-attack-remove-it.html

UML Use Case

http://www.developer.com/design/article.php/2109801

UML Class

http://www.developer.com/design/article.php/2206791

Topcoder Design