Answer / ayan banerjee

create type type_name as object
()

Answer / priya

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

What is the use of triggers?

0 Answers  

---

what is clause? : Sql dba

0 Answers  

---

What is secondary key?

0 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

what is blob? : Sql dba

0 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

How do I run a pl sql procedure in sql developer?

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

what is definer rights invoke rights?

1 Answers  

---