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.

Which data type doesn't allow null data type?

6 Answers   TCS,

---

What is primary key sql?

0 Answers  

---

What is an index in sql with example?

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

What is set serveroutput on?

0 Answers  

---

Explain what is a view?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

How can we make an if statement within a select statement?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---