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
- 5987 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 long does it take to learn pl sql?
What is the purpose of normalization?
How to create an array in pl/sql?
How many tables can you join in sql?
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What is indexes?
How many triggers can be implemented for a table?
Does pl/sql support create command?
Are pl sql variables case sensitive?
what is bcp? When is it used?
What is the file extension for sql database?
What is the difference between row level and statement level trigger?
-
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)
