Answer / Akhilesh Awasthi

VARRAY is a variable-length array data type in Oracle. It allows you to store an array of elements of the same data type, but the number of elements can vary within the table or index segment. When declaring a VARRAY, you need to specify its size and maximum size.

what is exact difference between drop and truncate table.

3 Answers  

---

Explain the family trees and connection by clause

0 Answers  

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

How a tablespace is related to data files?

1 Answers  

---

How to write date and time interval literals in oracle?

1 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

Why is oracle so popular?

1 Answers  

---

What is Index and different types of Indexes?

7 Answers  

---

What is difference between a formal and an actual parameter?

1 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

What privilege is needed for a user to delete rows from tables in another schema?

1 Answers  

---