what is the syntax of DELETE command?

Answer Posted / guest

delete from tablename where condition;

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Garbage Collection? and what is full recursive Garbage collection?

2384


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

641


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1358


What happens if recursive calls get out of control?

546


How many types of table in Oracle?

614






How to turn on or off recycle bin for the instance?

605


Why oracle is used?

578


How do I connect to oracle database?

533


Explain oracle data types with examples?

575


What is archive log in Oracle?

595


Why do you use stored procedures and state some of its disadvantages?

563


How to retrieve the count of updated rows?

572


What is the difference between primary key and unique key and foreign key in oracle?

544


Can we store pictures in the database and if so, how it can be done?

585


How can we create the complete backup of data in the oracle.

1682