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

971

---

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

1003

---

What is the difference between translate and replace in oracle?

1115

---

What are the different types of synonyms?

1078

---

How do you store pictures in a database?

952

---

What is the use of file param in imp command?

1117

---

What is a system tablespace?

1008

---

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

1227

---

What are the different types of modules in oracle forms?

952

---

What are the limitations of check constraint?

966

---

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

1002

---

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

970

---

Can you create a synonym without having a table?

980

---

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

1025

---

What is the usage of save points in oracle database?

909

---