Answer / Yajuvendra Singh

Generally, an INNER JOIN is faster than a LEFT JOIN because it produces fewer rows and requires less processing. However, the performance difference may vary depending on the specific data and query structure.

What is the maximum number of triggers, you can apply on a single table?

1 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

What is oracle pl sql developer?

1 Answers  

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

What are variables in pl sql?

1 Answers  

---

what does myisamchk do? : Sql dba

1 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What Is a Trigger? How Do You Use It?

3 Answers  

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

What are indexes, and what are the different types?

3 Answers  

---

what are the differences between char and nchar? : Sql dba

1 Answers  

---