what is the syntax of DELETE command?

Answer Posted / guest

select * from tablename

where col1=xyz
delete col1;

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1602


how to make an oracle object

1854


How do I spool to a csv formatted file using sqlplus?

544


How to delete all rows a table in oracle?

619


What happens to the current transaction if the session is killed?

536






How to open and close an explicit cursor in oracle?

573


What are operators in oracle?

525


How to delete a column in an existing table in oracle?

601


What is ordinary table in oracle?

647


In the oracle version 9.3.0.5.0, what does each number shows?

748


What is merge in oracle?

558


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1203


How to rename an index?

586


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1643


Is it possible to insert comments into sql statements return in the data model editor ?

2063