Answer / srinivas

We should give the maximum size when we declare the varry, and if u perform delete then it removes the values from the end, use this varray when u know the size


we no need to give the size when we declare the nested tables,we can remove the values any where from the nested table,use this when u don't know the size.

Answer / dandu devendra

Varray: constrain table.Basically this table dense by default indexs start with 1.
Nested table: unconstrain table.

Answer / prabu t

Varray -
Can be stored in the database.
Bounded (maximum length should be given).
Delete / Remove values only from the end.

Nested Tables -
Cannot be strored in the database.
Unbounded (No maximum length).
Delete / Remove values anywhere in the table.

What is an oracle stored procedure?

0 Answers  

---

Which join is like inner join?

0 Answers  

---

what is julian date in oracle

2 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

What are the parts of a sql statement?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

Can a view be mutating? If yes, then how?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

What is a natural join sql?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

What is the difference between microsoft access and sql server?

0 Answers  

---