Answer Posted / samir kumar sahoo

A plsql table can hold to a maximum of 1000 columns.

Point the difference between translate and replace?

1081

---

What is the data pump export utility?

1077

---

How to specify default values in insert statement using oracle?

1096

---

How to create lov dynamically at runtime & attach to text field?

1159

---

How to pass parameters to procedures?

1026

---

In which language oracle has been developed?

1069

---

How to define a data source name (dsn) in odbc manager?

1022

---

What is index-organized table in Oracle?

1063

---

Describe varray?

1052

---

How do I call oracle stored procedures that take no parameters?

1099

---

What is a nested table and how is it different from a normal table?

1044

---

Explain oracle left join with an example?

1002

---

Explain a data segment?

1059

---

How to connect to a local oracle 10g xe server?

988

---

Explain the use of tables option in exp command.

1107

---