Difference between decode and case.in which case we are using case and in which case we are using decode?with an example.
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 are used to define cursor variables. It acts as a pointer for memory area.In a single memory location (context area) we can write any number of select statement. Mainly it is used when you want to fetch data from more than one table. ...
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
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
