i want insert 10 records from table a to table b.
if i m using statement level trigger how many record insert
?in row level trigger how many record inserted???
Answers were Sorted based on User's Feedback
Answer / satheesh
statement level trigger=10
but row level trigger=1
| Is This Answer Correct ? | 3 Yes | 3 No |
Can a primary key be a foreign key?
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
What does pl sql developer do?
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.
What is time based sql injection?
Name some usages of database trigger?
. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST ACC a dv b fg b bh c mk c cl c so result:- A B c dv fg mk bh cl so
What is pivot in sql?
What is a behavioral trigger?
What is sql*loader and what is it used for? : aql loader
What is difference between cursor and trigger?
What is a pragma statement?
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)