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;

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4001

---

How many types of privileges are available in sql?

1337

---

Is sql better than excel?

1137

---

What is %rowtype in pl sql?

984

---

Mention what is the plv (pl/vision) package offers?

1098

---

What is multiple columns?

1056

---

Does varchar need length?

984

---

what is the difference difference between procedure and packages

10380

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

1001

---

what is the difference between a local and a global temporary table? : Sql dba

1060

---

What is the difference between microsoft sql and mysql?

954

---

What's the difference between a primary key and a clustered index?

982

---

Can you inner join the same table?

988

---

How do I debug a stored procedure?

1103

---

What is scalar data type in pl sql?

1058

---