Answer Posted / art

Composite Data Types:

Associative array (index-by table)
Nested table
Varray
Record

Associative arrays, nested tables, and varrays are also referred to as collections.

What happens if you use a wrong connect identifier?

1134

---

how to join query for one source type is oracle another source type is sql server ?

2476

---

What is a named program unit?

1135

---

How index is implemented in oracle database?

1040

---

how to handle exceptions in post production

1481

---

How to convert characters to numbers in oracle?

1110

---

What is logical backup in oracle?

1080

---

How to bring a tablespace offline?

1111

---

What is java oracle used for?

1074

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1083

---

Explain the difference between sap and oracle?

1081

---

What is the minimum client footprint required to connect c# to an oracle database?

1157

---

What is a package ? What are the advantages of package ?

1136

---

Can we write insert statement in function in oracle?

1153

---

Explain oracle data types with examples?

1076

---