Answer / Saurabh Kumar

The main difference between the conventional and direct path loaders lies in the method of writing data to the database. The conventional path writes data into temporary tables, which are then inserted into the target table(s). In contrast, the direct path writes data directly into the target table(s), bypassing the temporary tables, leading to faster loading times but with a higher risk of data corruption.

Explain the difference between 'between' & 'and' operators in sql

1 Answers  

---

what is try_catch block in procedure

1 Answers  

---

Does sql full backup truncate logs?

1 Answers  

---

What are the most important ddl statements in sql?

1 Answers  

---

What operators deal with null?

1 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

What kind of join is join?

1 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What is cursor in pl sql with examples?

1 Answers  

---

How can we optimize a sql query?

1 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

What are the most important characteristics of pl/sql?

1 Answers  

---