Can We write bulk collect statement in triggers?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I change database name in sql?

611


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

630


What is a relationship and what are they?

681


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1727


How is pl sql different from sql?

634






How do you copy a table in sql?

658


What is the maximum number of rows in sql table?

655


What is AUTH_ID and AUTH_USER in pl/sql ?

1811


How many columns should be in an index?

615


What are sql queries used for?

637


What is break?

719


What are pl sql procedures?

606


Why join is faster than subquery?

695


Are dml statements autocommit?

643


define data blocks ? : Sql dba

653