Answer Posted / pradeep

A collection is an ordered group of elements, all of the
same type. It is a general concept that encompasses lists,
arrays, and other familiar datatypes. Each element has a
unique subscript that determines its position in the collection.

PL/SQL offers these collection types:

* Index-by tables,
* Nested tables
* Varrays

What is left join in postgresql?

995

---

What is sql partition function?

1116

---

Can a primary key be a foreign key?

969

---

What is sql indexing?

963

---

Explain the working of foreign key?

976

---

What is the purpose of using pl/sql?

1075

---

What is difference between stored procedure and trigger?

1058

---

How do I write a sql query in pgadmin 4?

924

---

How does left join work in sql?

938

---

What are different joins used in sql?

1007

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

897

---

what is a view? : Sql dba

1026

---

explain access control lists. : Sql dba

946

---

Why is the cursor important?

977

---

What does seeding a database mean?

891

---