select * from tablename where col1=xyz delete col1;

what is the syntax of DELETE command?

Question Posted / guest

8 Answers
11616 Views
I also Faced
E-Mail Answers

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

List the various oracle database objects?

1008

How to check database size in Oracle?

1135

How to apply filtering criteria at group level in oracle?

1001

What is the difference between truncate & delete command?

1141

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2003

Difference between pre-select and pre-query

1048

What is recovery manager in Oracle?

1004

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2158

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

3837

How many types of tables supported by oracle?

1029

Why do we need integrity constraints in a database?

984

How does oracle handle read consistency?

1058

How to define a record variable to store a table row?

1021

What is difference between cartesian join and cross join?

1033

Explain an index?

1103