Why do you use stored procedures and state some of its disadvantages?

1028

---

How to convert a date to char in oracle? Give one example.

1068

---

What is the difference between translate and replace in oracle?

1166

---

What are the different types of synonyms?

1140

---

How do you store pictures in a database?

1007

---

What is the use of file param in imp command?

1165

---

What is a system tablespace?

1080

---

In the oracle version 9.3.0.5.0, what does each number shows?

1302

---

What are the different types of modules in oracle forms?

1001

---

What are the limitations of check constraint?

1033

---

How to convert a string to a date in oracle database?

1054

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

---

Can you create a synonym without having a table?

1042

---

What are the components of logical database structure in oracle database?

1088

---

What is the usage of save points in oracle database?

964

---