Explain the difference between triggers and constraints?
No Answer is Posted For this Question
Be the First to Post Answer
there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?
How do I remove all records from a table?
What are commit, rollback, and savepoint?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
Explain what is an index?
Write one update command to update seqno field of a table on the basis of row number.
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are the differences between Database Trigger and Integrity constraints ?
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.
What are the topics in pl sql?
what happens if null values are involved in expressions? : Sql dba
Difference between inline query and stored procedure?
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)