Answer / Lokendra Saran

A nested table is a type of Oracle object that behaves like an array within a row of another table. Unlike a normal table, each row in a parent table can contain multiple rows of data in its associated nested table.

What is oracle latest version?

0 Answers  

---

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

---

What are the differences between primary key and unique key?

1 Answers  

---

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,

---

why dont we assign not null constraint as table level constraint.

1 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1 Answers  

---

What is difference between truncate and delete?

1 Answers  

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---

Explain can a view based on another view?

1 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1 Answers  

---

What is set operator oracle?

1 Answers  

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1 Answers   HCL,

---