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 CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

What program will open a mdb file?

0 Answers  

---

what is data integrity? : Sql dba

0 Answers  

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What is bulk collections?

2 Answers  

---

Does sqlite need a server?

0 Answers  

---