File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes diff b/w stored proc and triggers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "diff b/w stored proc and triggers" Watch "diff b/w stored proc and triggers" New topic

diff b/w stored proc and triggers

pravanya Gullapudi

Joined: May 07, 2007
Posts: 16
difference between stored procedures and triggers?
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Did you try googling, or reading your database's documentation? Either source is liable to give you a fuller answer than one you will get here. The basics are a trigger is something that happens on specific events in the database, a stored procedure is a piece of functionality stored and run in the database.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: diff b/w stored proc and triggers
It's not a secret anymore!