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

Differentiate between post-database commit and post-form commit?

0 Answers  

Please explain oracle data types with examples?

0 Answers  

What to do if dba lost the system password?

0 Answers  

What types of joins are used in writing subqueries?

0 Answers  

wirte the syntax of update query?

3 Answers   IBM,

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

am completed mca2011 how get certification in oracle

1 Answers  

What is the difference between Outer join and Full outer join?

5 Answers  

What is varray?

0 Answers  

What is RULE-based approach to optimization ?

1 Answers  

What is the difference between post-database commit and post-form commit?

0 Answers  

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers