Answer / malini paul

delete from <tablename> where <condition>;

Answer / chand

THE BELOW QUERY DELTES A ROW BASED ON A CONDITION
DELETE FROM <TABLE_NAME>
WHERE <COL_NAME>=<CONDITION>

Answer / amit bhagat

delete from table where col_name=value

Answer / sriramya

delete table_name where col_name=value;

Answer / vishwajeet chaudhary

delete table_name where row_no=1

What is Trigger in Oracle?

0 Answers   MCN Solutions,

---

How to convert characters to numbers in oracle?

0 Answers  

---

How to commit the current transaction in oracle?

0 Answers  

---

Explain a synonym?

0 Answers  

---

How to bring a tablespace online?

0 Answers  

---

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

What is a subquery?

0 Answers  

---

How to estimate disk space needed for an export job?

0 Answers  

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,

---

How many types of tables supported by oracle?

0 Answers  

---

What is define in oracle?

0 Answers  

---