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
- 6004 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 memory optimized?
What is a null value?
Explain about various levels of constraint.
what happens if you no create privilege in a database? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
What is sql resultset?
How to fix oracle error ora-00942: table or view does not exist
What is multiple columns?
What is the difference between join and union.
27 Answers 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,
What are the types of views in sql?
What are sql functions? Describe the different types of sql functions?
-
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)
