Can We write bulk collect statement in triggers?
Answer / kishore
Sure,we can write bulk collect in triggers also.
Bulk Collect purpose is just to retrieve the multivalues of
attribute into a collection(like array,record,tables etc)
| Is This Answer Correct ? | 22 Yes | 0 No |
What are the advantages of stored procedure?
What are the syntax and use of the coalesce function?
How would you convert date into julian date format?
What is cursor status?
How do I view a table in sql?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
What is the fastest way of accessing a row in a table?
Why having clause is used in sql?
What is dml with example?
Explain what is rdbms?
What are the difference between Functions/Stored Procs and Triggers and where are they used.
What is pl sql in dbms?
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)