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

How to convert a date to char in oracle? Give one example.

1069

Explain temporal data types in oracle

1098

candidate key is subset of super key but not vice-verse explain

2070

How do I call oracle stored procedures that take no parameters?

1121

What is BBED in Oracle?

1157

How to convert characters to times in oracle?

1023

List out the difference between commit, rollback, and savepoint?

1037

What is set verify off in oracle?

1106

What would you do with an in-doubt distributed transaction?

1980

In which language oracle has been developed?

1076

How to upsert (update or insert into a table)?

1005

How to define a sub function?

1136

What is primefaces used for?

1050

Can a formula column referred to columns in higher group ?

2506

What do you understand by a database object? Can you list a few of them?

1018