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

What is the maximum number of triggers, you can apply on a single table?

1048

---

What is sql resultset?

1041

---

Can we use view in stored procedure?

955

---

Which software is used for pl sql programming?

1034

---

Can unique keys be null?

949

---

What is an emotional trigger?

1057

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2067

---

How to raise user-defined exception with custom sqlerrm ?

1178

---

What do you mean by dbms? What are its different types?

1065

---

What are the parts of a sql statement?

1143

---

Is truncate ddl or dml?

1038

---

How to download oracle sql developer?

1167

---

What is a boolean in sql?

1025

---

Explain the methods used to protect source code of pl/sql.

1074

---

Write a sql query to convert all character to uppercase after hypen.

1484

---