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

Explain the update statement in sql

916

---

What is an index in sql with example?

919

---

Compare sql & pl/sql

1046

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

990

---

Can delete statement be rollbacked?

930

---

Is like operator in sql case sensitive?

961

---

What is sql table?

902

---

Sql technical questions

1201

---

What is sql analyzer?

958

---

Can ddl statements be used in pl/sql?

1068

---

How can a pl sql block be executed?

889

---

What do you mean by stored procedures?

951

---

How do I create a sql database?

947

---

What does an inner join do?

1090

---

Is record in oracle pl sql?

902

---