Watch Our YouTube Channel
It is currently Tue Jan 23, 2018 1:58 am
 

All times are UTC



Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Thu Nov 03, 2016 9:08 am 
Offline

Joined: Fri Nov 13, 2015 3:56 am
Posts: 460
Function can be a part of expression

Function can be called from SQL statements where as procedure can not be called from the sql statements.

Functions are normally used for computations where as procedures are normally used for executing business logic.

Functions can be used in select or update or delete statement.

A function always return a values while procedure can return one or more values through Parameters

Trigger gets automatically executed when insert update or delete is fired on a table.

It is a type of stored procedure invoked automatically for a predefined DML operation .cannot accept parameters.

Triggers provide a way of executing PL/SQL code on the occurrence of specific database events.

commit cannot be done in case of triggerrs except for autonomous transactions.

when you create a trigger you have to identify event and action of your trigger.

Triggers are implicitly called by DB itself

_________________
Learn Web Development | Latest Technology News |Motivational Quotes


Top
 Profile  
Reply with quote  
PostPosted: Tue Jan 10, 2017 5:53 am 
Offline

Joined: Wed Jul 01, 2015 11:28 am
Posts: 172
Location: Bangalore
Nice information provided. Thanks for the post.

_________________
Digital Marketing Company in India| Web Design Company in India | SEO Services in India


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron