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
- 6165 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
Can I call a procedure inside a function?
What are local and global Indexes and where they are useful.
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How do you truncate?
Is sql between inclusive?
What language is oracle sql developer?
Is primary key an index?
What is sql keyword?
What is clause in sql?
What is meant by truncate in sql?
what is datawarehouse? : Sql dba
what is the difference between nested subquery and correlated subquery?
What is the basic form of sql query?
What are the basic techniques of indexing?
What is meant by cursor in sql?
