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 |
What is the process of debugging?
What is normalisation and its types?
What are string functions in sql?
How do I start sql profiler?
How can we find duplicate records in a table?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Why query optimization is needed?
how do you tune the slow running queries in oracle db , explain the methodology
Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.
How many rows will return from dual table?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Can we use join in subquery?
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)