Answer Posted / priya

create type type_name as object
(
No NUMBER,
Name Varchar2(15),
City VARCHAR2(30,
POSTALCODE CHAR()
);

What does truncate mean in sql?

1026

---

What is the difference between nested table and varray?

1004

---

What is a natural join sql?

977

---

What is primary key and foreign key with example?

932

---

Is vs as in pl sql?

987

---

What is the most common sql injection tool?

1042

---

what is subquery? : Sql dba

1135

---

How many indexes can be created on a table in sql?

1055

---

What is the cause of mutating table error and how can we solve it?

1049

---

How do you change a value in sql?

1019

---

Can we perform dml on view?

1044

---

What is on delete set null?

1090

---

what tools available for managing mysql server? : Sql dba

1086

---

How to make a copy values from one column to another in sql?

1037

---

Can %notfound return null after a fetch?

1060

---