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,

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

---

What is the difference between a database and a relational database?

0 Answers  

---

What is sql in oracle?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

Can dml statements be used in pl/sql?

0 Answers  

---

Does inner join return duplicate rows?

0 Answers  

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---