what is the syntax of DELETE command?

Answer Posted / ajeet singh

For delete any record from table :-

delete form <tablename> where <condition>;


For delete any column fromm table :-

alter table <tablename>
drop column <columnname>;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter a new row into a table interactively?

544


How can we force the database to use the user specified rollback segment?

556


What is query image?

584


What is set operator oracle?

526


What is ordinary table in oracle?

647






How to rename a tablespace in oracle?

615


how can we store any pdf file in oracle

1638


What are the ansi data types supported in oracle?

518


Explain a synonym?

600


What is a lookup table in oracle?

540


How translate command is different from replace?

542


What is bulk load in oracle?

589


State and explain about oracle instance?

545


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

3342


Explain the use of grant option in imp command.

576