Answer Posted / richa

In pl/sql we have two types of datatypes
1. scalar
2. composite.

In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.

While in Composite u can store whole row mean if one row
have 3 columns so u can store 3 values in a composite
datatype variable at a time.
Ex. emp employees%rowtype ;
Mean if enployees have 3 columns so in variable emp u can
store 3 values of 3 columns at a time .

What is bulk collect in oracle?

1051

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2500

---

What is query image?

1022

---

What is the simplest tool to run commands on oracle servers?

1052

---

Explain how are indexes update?

1116

---

What is a proxy object?

1102

---

How to create a new table in oracle?

1228

---

Can we protect our pl/sql source code?

1079

---

Explain implicit cursor.

1072

---

Explain the use of online redo log files in oracle.

1075

---

What is MTTR advisor in Oracle?

1133

---

Does facebook use oracle?

1078

---

How to define a specific record type?

1132

---

Explain parameter file in oracle.

1079

---

What are the logical operations?

1169

---