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  

How to retrieve the count of updated rows?

0 Answers  

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

0 Answers  

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

What are the different oracle database objects?

0 Answers  

How to insert multiple rows with one insert statement in oracle?

0 Answers  

What are virtual columns?

2 Answers   TCS,

How to display row numbers with the records?

0 Answers  

How to get execution statistics reports on query statements?

0 Answers  

How would you design a database for an e-commerce website?

1 Answers  

What are the limitations oracle database 10g xe?

0 Answers  

difference between procedures and function?

7 Answers   IBM,