Creation of cursors and triggers in sql

[harikreative]

Hi All!!!

Can any one guide me on creation of cursors and triggers in sql and how to call them from the front end...

Thanks,
Hari

[caradoc]

Hari,

Cursors are used as part of your stored procedures along with pl/sql blocks. triggers are defined on tables on events..

triggers get executed automatically depending on the event you code..

Please refer to oracle tutorials here ...

http://www.exforsys.com/content/category/17/261/343/

http://www.exforsys.com/content/category/17/220/267/

It should get you started... first you need to understand the concepts before asking these kind of questions since they are not one line answer questions.

Thanks,