Hi Vishal,

> I would also like to know that if I need to learn Triggers and Stored
> Procedures then what document should I refer, I am am new for triggers
> and SP. Googling is random way I see. Would you refer any good books
> for this?

You'll find lots of free documentation under

http://www.firebirdsql.org/en/documentation/

More specifically, here's the Language Reference:


http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25.html

with the chapter on triggers:


http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-trgr.html

and on Procedural SQL (the language you use inside triggers and Stored
Procedures):


http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-psql.html

The Firebird FAQ is also very useful:

http://www.firebirdfaq.org/

And Helen Borrie's Firebird Book is a great manual which also includes
chapter(s) on SP's, triggers and PSQL. It's not free though! You'll find
it here:

https://www.ibphoenix.com/

(You may need to scroll down a bit.)

Hope this helps!

Cheers,
Paul Vinkenoog