Interested to Buy Any Domain ? << Click Here >> for more details...
What are the difference between Functions/Stored Procs and
Triggers and where are they used.
- 1 Answers
- 6074 Views
- CGI, TCS, I also Faced
- E-Mail Answers
Answer Posted / barun
Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)
Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_
trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicate records from a table?
What is pragma in sql?
How do I restart sql?
what are the difference between clustered and a non-clustered index? : Sql dba
what are numeric data types? : Sql dba
What does the base_object_type column shows in the user.triggers data dictionary view?
What is %s in sql?
How many rows can sqlite handle?
What is right join in sql?
Why is a primary key important?
What is difference between sql and mysql?
What are properties of the transaction?
What is set serveroutput on in pl sql?
What is a data definition language?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
