Can we use commit inside a trigger?
No Answer is Posted For this Question
Be the First to Post Answer
Why commit is not used in triggers?
What is intersect?
How to get the 3rd column(i.e all the data along with the column name)in a table?
How to prepare for oracle pl sql certification?
what is the difference between delete and truncate commands? : Sql dba
What is the difference between function and procedure in pl/sql?
What is Materialized View? In What Scenario we Use Materialized View?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the usage of when clause in trigger?
How to assign sql query results to pl sql variables?
what is called after appearing where clause
what is the difference between cluster and non cluster index? : Sql dba
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)