how can i create a user defined datatype

3 Answers  

---

What is type and rowtype in pl sql?

0 Answers  

---

What are hotfixes and patches?

0 Answers  

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---

---

What are the two types of periodical indexes?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

How to rename a table?

0 Answers  

---

Which command is used to delete a trigger?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---