select * from tablename where col1=xyz delete col1;

what is the syntax of DELETE command?

Question Posted / guest

8 Answers
11783 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 is oracle database client?

1015

List out the types of joins.

1137

What is connection pooling in oracle?

950

How do I learn what codesets are available in oracle?

1026

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1929

How to view the data files in the current database?

1080

How to install oracle database 10g xe?

997

How to recover a dropped table in oracle?

1022

how to join query for one source type is oracle another source type is sql server ?

2407

what is the difference between functional dependecy and multilevel dependency?

2445

What is an oracle?

995

Can we create trigger on materialized view in oracle?

966

How to create a table index in oracle?

1114

What is the usage of analyze command in oracle?

1078

What is control file used for?

1178