it is highly recommended........that
tell me exact difference between storedprocedure and trigger

It is highly recommended for you to read this.

Member Avatar for hfx642

Always handy to have a set of Oracle Docs with you.

To answer your question in 50 words (or less)...

A trigger is a code segment which responds to an event which occurs on DML of a table.
A "Stored Procedure" can be; a Package, a Procedure, or a Function, which is stored in the database.

commented: agree +13
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.