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 |
How many functions are there in sql?
What is the difference between inner join and left join?
What is scalar function?
What does count (*) mean?
Can we insert in sql function?
What is the difference between partitioning and sharding?
Explain the difference between drop and truncate commands in sql?
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
wtite down triggr not any entry on Sunday
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
What is rtm in testing?
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)