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 .

How to create a stored procedure in oracle?

1151

---

How a tablespace is related to data files?

1165

---

How to pass a cursor variable to a procedure?

1158

---

How to insert multiple rows with one insert statement in oracle?

1134

---

What do you understand by database schema and what does it hold?

1299

---

Can a parameter be passed to a cursor?

1180

---

Write a trigger example in oracle?

1114

---

How to export data with a field delimiter?

1085

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2078

---

How to store pictures on to the database?

1033

---

What is blob data type in oracle?

1207

---

Explain an index?

1182

---

Is insert autocommit in oracle?

1131

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2759

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5681

---