Answer Posted / shriram

It is a type of composite data type in pl sql .. The other
two composite types are nested tables and varrays .. example :
TYPE type_name IS TABLE OF NUMBER INDEX BY VARCHAR2(64);
name type_name;

It is also called as index by tables.
Now "name" can be given any values like :

name('raja'):=100;

What is database migration?

517

---

What is union and union all keyword in sql and what are their differences?

574

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

531

---

What is exception? What are the types of exceptions?

554

---

What is pl sql block in dbms?

524

---

---

What is trigger in flip flop?

516

---

Mention what does the hierarchical profiler does?

557

---

What is a delimiter in sas?

546

---

What is cursor explain with example?

551

---

which tcp/ip port does sql server run on? : Sql dba

515

---

What does t sql mean?

532

---

How do I enable sql encryption?

518

---

Explain what is a field in a database and record in a database?

604

---

How can you fetch first 5 characters of the string?

550

---

What are the two types of periodical indexes?

503

---