Answer Posted / priya

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

Is pl sql a programming language?

550

---

Is pl sql different from sql?

536

---

What is restrict in sql?

557

---

what is uncommittable transactions? : Transact sql

570

---

Write a query to find the names of users that begin with "um" in sql?

505

---

---

how to rename an existing table in mysql? : Sql dba

576

---

What is mutating sql table?

611

---

Mention what is the use of function "module procedure" in pl/sql?

569

---

How many primary keys can a table have?

534

---

Can I join the same table twice?

526

---

what is meant by urlencode and urldocode? : Sql dba

603

---

What is a sql trace file?

550

---

What is a natural join?

518

---

What are the parts of a basic sql query?

516

---

What are sql*plus environment variables?

559

---