Answer Posted / avi007

We can create a user defind datatype by using abtract
datatype.

create type address_type as object
( street varchar2(10),
pincode number(6);
);

This is used in

create table emp
(Empname varchar2(20),
Adress address_type);

// address_type is user defined datatype

How do you change a value in sql?

1023

---

What is the difference between a database and a relational database?

1107

---

What port does sql server use?

1065

---

how to create a new table in mysql? : Sql dba

991

---

What is the maximum size of sqlite database?

1112

---

what is the difference between blob and text? : Sql dba

1027

---

explain commit and rollback in mysql : sql dba

1024

---

What are stored procedures in mysql?

1019

---

What is the difference between execution of triggers and stored procedures?

1120

---

Is big data nosql?

957

---

What is join view in sql?

949

---

What is sql in java?

1096

---

What is varray in pl sql?

1080

---

What are the different types of a subquery?

1053

---

Explain lock escalation? : Transact sql

1206

---