When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

Give an example of Full Outer Join?

1 Answers   IBM,

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

Why are sql stored procedures used?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is record variable?

0 Answers  

---

How to select 10 records from a table?

0 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---