select * from tablename where col1=xyz delete col1;

what is the syntax of DELETE command?

Question Posted / guest

Answer Posted / guest

select * from tablename

where col1=xyz
delete col1;

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the Tune Query

2340

What is a trigger oracle?

1133

What is bind variable in oracle 11g?

1091

6. Display the client name and order date for all orders using the traditional method.

2353

Difference between open_form and call_form in oracle.

1217

How do I find my oracle client driver version?

1090

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2165

What is a cursor and what are the steps need to be taken?

1277

what are the advantages of running a database in archive log mode?

2250

What is the dynamic sql in oracle?

1120

What is Segment Advisor in Oracle?

1142

What is the difference between PFILE and SPFILE in Oracle?

1104

Explain the use of rows option in exp command.

1145

How to call a stored function with parameters?

1088

What are the major difference between truncate and delete?

1129