Latest Answer: Maximum we can write 28 triggres on table3 -> insert, update and delete4 -> combination of insert, update and delete2 -> trigger type (for each row and statement)2 -> trigger event (before and after)(3+4)*2*2 = 28 ...
Explain what is mutation and what is mutating table and how this mutation problem is solved in a table
Latest Answer: When you drop a table, normally the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later be recovered with the FLASHBACK TABLE statement if ...
Latest Answer: An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query. ...
Latest Answer: LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1, children of the root are level 2, grandchildren are ...
What is the difference between single quote (') and double quote(") in relates to using in SQL. When do you use 'xxx' and "xxx"? what is the difference both of them?
How to delete set of records at a time where all the records having same values , except the Rowid differs?
Latest Answer: the ROWNUM is a number(like serial no) which is dynamically changes.but the ROWID does not change.Because it is having the unique address,which is generated by the oracle ...
SESSION 1DELETE FROM EMP; SESSION 2 SELECT * FROM EMP;What will be the result?
Latest Answer: Please Try This Query on SQL Prompt And see the best result as per Requirement.select * from(select rownum rowno, emp.* from emp) line_emp where line_emp.rowno between &a and &b;Thanks,Salil Sharma ...
View page << Previous 6 7 8 9 [10] 11 12 13 14 15 Next >>
Go Top
