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 difference between triggers and constraints?

963

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1572

---

What are data types in pl sql?

1126

---

What is not in sql?

936

---

What is a memo field?

949

---

What does the sign mean in sql?

968

---

How can check sql version from command line?

1065

---

Is a secondary key the same as a foreign key?

1016

---

How do sql databases work?

984

---

What are the benefits of stored procedures?

1051

---

What is composite data type in pl sql?

1082

---

What is database migration?

952

---

how do you control the max size of a heap table? : Sql dba

960

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1133

---

How do I view output in sql developer?

1070

---