Answer / mv

we can create a user defined data type by using subtype.

Answer / vetrikumaran

WE CAN CREATE A USER DEFINED DATATYPE BY USING RECORD DATATYPE..

RECORD,INDEX BY TABLE ARE NOT BUT USER DEFINED DATATYPES

Answer / 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 happens when a trigger is associated to a view?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What programs use sql?

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

How does cross join work in sql?

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

How to select 10 records from a table?

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

---

What is file based approach?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

what is a constraint? : Sql dba

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---