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 privilege is needed for a user to delete rows from tables in another schema?

0 Answers  

master table and child table performances and comparisons in Oracle ?

0 Answers  

What is blob data type in oracle?

0 Answers  

What is the string concatenation operator in oracle?

0 Answers  

What is null value in oracle?

0 Answers  

How to do paging with oracle?

0 Answers  

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  

What is clustered table in Oracle?

0 Answers   MCN Solutions,

What is a static data dictionary in oracle?

0 Answers  

What is clusters ?

2 Answers  

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

What are the different oracle database objects?

0 Answers