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.

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

How do I use google cloud in sql?

0 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

---

What is substitution variable?

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

Why stored procedure is faster than query?

0 Answers  

---