Answer / Vijay Pal

A varray (VARIABLE ARRAY) in PL/SQL is a variable that holds an array of elements. Unlike arrays, varrays can be declared within PL/SQL blocks and stored in PL/SQL tables.

Can we join more than 2 tables in sql?

1 Answers  

---

What is relationship? How many types of relationship are there?

1 Answers  

---

How to test for null values?

1 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is group by in sql?

1 Answers  

---

what is acid property in database? : Sql dba

1 Answers  

---

What is java sql connection?

1 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What is a schema? How is it useful in sql servers?

1 Answers  

---

how to get a list of all tables in a database? : Sql dba

1 Answers  

---