select * from tablename where col1=xyz delete col1;

what is the syntax of DELETE command?

Question Posted / guest

8 Answers
11547 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

What are group functions in oracle?

972

How to create a new oracle data file?

969

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2412

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2218

How to delete multiple rows from a table in oracle?

1003

Is truncate autocommit in oracle?

1020

What is memory advisor in Oracle?

1022

What is a cursor in oracle?

1106

How to create a new table in your schema?

1028

Where are the settings stored for each instance in oracle?

1060

How to convert numbers to characters in oracle?

967

What is an oracle tablespace?

981

Is primary key indexed by default in oracle?

928

what are steps for interface? where is exchange rate defined in which table?

2054

How to use "if" statements on multiple conditions?

1111