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

How to delete multiple rows from a table in oracle?

0 Answers  

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

What is transport network substrate (tns) in oracle?

0 Answers  

What is ceil and floor in oracle?

0 Answers  

How can we delete duplicate rows in a table?

0 Answers  

How to calculate date and time differences in oracle?

0 Answers  

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

1 Answers   IBM,

i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?

5 Answers   Oracle,

What is an Oracle sequence?

1 Answers  

What is difference between truncate and delete?

0 Answers