What are the uses of Cursor,Function,Stored Procedure,Trriger.

Procedure : They are a pl/sql block which you can use to define logic around the data before/after operating into it. We generally call Stored Procedure to do most of the operation to have better grip over our data. Also using Stored Proc it gives an additional block where you can easily change your logic without deploying the application.

Function : These are small code blocks that gets some input from outside world and returns one output. Functions are used to call from the storedproc or any sql objects. We dont call Functions directly form .NET objects

Cursor : This is actually a temporary table created during execution of a pl/sql body. This is used to fetch records from a select query, hence helps in manipulating data.

Trigger: They are pl/sql blocks that are called automatically when some DML operation is performed. So if you want your block to be executed automatically use trigger.


I hope you like my explanation.

www.abhisheksur.com

Sapna, if this helps please login to Mark As Answer. | Alert Moderator

Better read the following book

http://books.google.co.in/books?id=a1365oRKX8YC&pg=PA779&lpg=PA779&dq=Stored+Procedures,Cursors,Functions+triggers+sqlserver&source=bl&ots=XZrgys8vP6&sig=UgK-cu-BesOXmj_a58ecTuOUVBs&hl=en&ei=4C-FS-qnINGfrAfX5YSXAw&sa=X&oi=book_result&ct=result&resnum=8&ved=0CCEQ6AEwBw#v=onepage&q=&f=false

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Sapna, if this helps please login to Mark As Answer. | Alert Moderator

Trigger

1)When you create a trigger you have to identify event and action of your trigger
2)A trigger is a pl/sql block structure which is fired when a DML statements like Insert, Delete, Update is executed on a database table. .
3) A trigger is triggered automatically.
4)It does not pass parameters

Stored procedure

1)Explicitly executed by invoking call to SP
2)you can not join SP
3)We can call a stored procedure from front
4)Stored procedure can take the input parameters

Function

1)can be used with Select statement
2)Not returning output parameter but returns Table variables
3) Cannot have transaction within function
4)Cannot be used to change server configuration

Sapna, if this helps please login to Mark As Answer. | Alert Moderator

Nice explanation Ms.Muhsinathk

Thanks & Regards
Hari

Sapna, if this helps please login to Mark As Answer. | Alert Moderator

Thanks Mr.Hariinakoti

Sapna, if this helps please login to Mark As Answer. | Alert Moderator

Hi Ms.Sapna

Please Mark as Answer if it helpful to you..That helps other who search the same...

Sapna, if this helps please login to Mark As Answer. | Alert Moderator