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
- 6070 Views
- CGI, TCS, I also Faced
- E-Mail Answers
Answer / 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 |
what is a composite primary key ? : Sql dba
What is trigger point?
Can we call stored procedure in function?
Does view contain data?
What does sql stand for?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
what is csv? : Sql dba
What is a database event trigger?
What is an alias command?
What is group function in sql?
what is bcp? When does it used? : Sql dba
What is set serveroutput on in pl sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
