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

How can you merge two tables in oracle?

780


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

1810


What are the different types of partitions in oracle?

766


What are the system predefined user roles?

822


How to omit columns with default values in insert statement in oracle?

843


Where do we use decode and case statements?

784


Does oracle partitioning improve performance?

778


What is the difference between pre-select and pre-query?

895


What is the difference between sharding and replication?

723


How to experiment a data lock in oracle?

831


How to use "out" parameter properly?

866


What is format trigger?

1874


Can we create trigger on materialized view in oracle?

786


What is the fastest query method to fetch data from the table?

1137


Explain the use of grant option in exp command.

807