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

difference between truncate and delete ,drop?

3 Answers  

does the query needs a hint to access a materialized view?

0 Answers  

How to rebuild an index in oracle?

0 Answers  

how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

What is a public synonym?

1 Answers  

What is currency type in database ?

3 Answers   TCS,

various types of hints and their usage

0 Answers  

what is difference between sql plus and sql*plus? (not sql and sql plus).

0 Answers  

How to define a data source name (dsn) in odbc manager?

0 Answers  

What is index in Oracle?

0 Answers   MCN Solutions,