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 integrity and what is constraint??Explain with example

1995


How to apply filtering criteria at group level in oracle?

823


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

807


How to best split csv strings in oracle 9i?

801


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1873


How to add a new column to an existing table in oracle?

864


Explain the use of parfile option in exp command.

761


What is the recommended interval at which to run statspack snapshots, and why?

2678


Explain the use of indexes option in exp command.

789


How can we delete duplicate rows in a table?

747


Is there a combination of "like" and "in" in sql?

826


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1207


How to use regular expression in pattern match conditions in oracle?

804


What are the most common interview questions on ETL Testing for experience?

875


What is meant by joins?

841