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
- 6080 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 |
How do I create a sql script?
What are the query optimization techniques?
What is recursive join in sql?
Are pl sql variables case sensitive?
Can we use commit inside a trigger?
Why do we use procedures in pl sql?
Is truncate ddl or dml?
What are pl/sql packages?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
How to run sql functions in pl/sql?
What is 19 null in sql?
What is parameter substitution in 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)
