Answer / Deepak Nigam

SQL*Loader doesn't directly support loading binary data like images, sound clips, or documents into the database. However, you can convert these files into base64-encoded strings and then store them in a CLOB or BLOB column.

What are different types of triggers?

1 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

What are stuff and replace function?

1 Answers  

---

Difference between truncate, delete and drop commands?

1 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

What is difference between inner join and cross join?

1 Answers  

---

Why do you partition data?

1 Answers  

---

What is the difference between a primary key and a clustered index?

1 Answers  

---

What are all ddl commands?

1 Answers  

---

What is clause in sql?

1 Answers  

---

What is the difference between local variables and global variables?

1 Answers  

---