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 |
write a query to delete similar records in different tables with same structure
What is the purpose of the partition table?
Does sql*plus have a pl/sql engine?
What is trigger types of trigger?
How do you respond to dementia behavior?
what is 'mysqlimport'? : Sql dba
while loading data into database how can u skip header and footer records in sql*loader
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
what is the Default Libraries for Oracle Report 6i
what is constraining table?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
what is global table
Oracle (3253)
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)