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 |
How to execute a stored procedure?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What are the advantages of sql? Explain
Is nosql faster than sql?
what are different types of collation sensitivity? : Sql dba
Give the order of sql select?
What is nosql db?
What is crud diagram?
What is sqlcontext?
what is the forward decleration in packages?
What are all the different types of indexes?
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
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)