1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

What is record variable?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is the difference between having and a where in sql?

0 Answers  

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

Does truncate table reset auto increment?

0 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

Explain the update statement in sql

0 Answers  

---