Answer / Shalu Singh

SQL hints are used to influence how the SQL optimizer processes a query. You can pass hints in your SQL statement by using the keyword 'hint' followed by the hint name and its value. For example: SELECT /*+ INDEX(my_table idx_name) */ * FROM my_table;

How long will it take to learn pl sql?

1 Answers  

---

What is the basic structure of an sql?

1 Answers  

---

What is sql indexing?

1 Answers  

---

What is difference between table and view?

1 Answers  

---

Is left join inner or outer by default?

1 Answers  

---

How many types of sql are there?

1 Answers  

---

what is error ora-03113: end-of-file on communication channel?

1 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

Does truncate need commit?

1 Answers  

---

Why is a trigger used?

1 Answers  

---

What is pl sql block structure?

1 Answers  

---

What is an Integrity Constraint?

4 Answers  

---