What is the result ofselect * from table1, table2there is a common column between them but no where caluse has been specified
Latest Answer: Ref cursor is a cursor variable used to point a cursor statement. Ref cursor mainly used for returning the cursor values. ...
How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.
Latest Answer: nice reply sir ...
SQL Queries- Say for Eg.Two Tables - EMP and DeptEMP Tables consist of Empno, Deptno, Mgrid, Empname, LocationDept Table Consist of Deptno, Deptname.1. Write a query to select Department name for which there is more that 20 employees in a specific Department. List the deptname and no of employees.Deptno in Emp table is the primary key for deptno column in Dept Table.2. Write a query to select Manager name for each employee. MGRID column in the emp table is the empid of the Manager. There should
Latest Answer: View based on multiple tables are up-datable using INSTEAD OF triggers. ...
Can one use dynamic SQL statements from PL/SQL?How can I use a variable for the columns/tables in the select statements?
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 ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
