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

1080

---

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

1109

---

What is the difference between translate and replace in oracle?

1218

---

What are the different types of synonyms?

1204

---

How do you store pictures in a database?

1060

---

What is the use of file param in imp command?

1221

---

What is a system tablespace?

1136

---

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

1352

---

What are the different types of modules in oracle forms?

1053

---

What are the limitations of check constraint?

1078

---

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

1105

---

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

1069

---

Can you create a synonym without having a table?

1096

---

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

1139

---

What is the usage of save points in oracle database?

1017

---