Answer / satish

Do the explain plan.if it is not using ur created index
then use hints to use ur created index

Answer / suresh ramsing

You execute your query like
explain plan for select sal from emp where empno='1224';
after that check this below one.
select * from table(dbms_xplan.display);
here u can find it'll be excuted by using index or TABLE ACCESS FULL

Answer / manoranjan sethy

by using SET AUTOTRACE ON EXPLAIN tool you can came to know weather such index is working or not.

difference between cursor and procedure in a package

3 Answers   PCS,

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

What is the use of stored procedures?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

Define overloaded procedure?

0 Answers  

---

How many types of primary keys are there?

0 Answers  

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---