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.

How can a pl sql block be executed?

0 Answers  

---

What is procedure and function in sql?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

How can you save or place your msg in a table?

0 Answers  

---

How to get second highest salary from a table

3 Answers  

---

Why do you partition data?

0 Answers  

---

What is numeric function sql?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

What is the execution plan in sql?

0 Answers  

---

What is pl/sql and what is it used for?

4 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---