What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ?
What is difference between ms sql and mysql?
what is a database? : Sql dba
What is the difference between alter trigger and drop trigger statements?
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?
what are the different functions in sorting an array? : Sql dba
How do I remove all records from a table?
Explain the savepoint statement.
What are different types of joins ?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is the difference between stored procedure and view?
Differentiate between pl/sql and sql?
Why stored procedure is better than query?
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)