Answer / malini paul

delete from <tablename> where <condition>;

Answer / chand

THE BELOW QUERY DELTES A ROW BASED ON A CONDITION
DELETE FROM <TABLE_NAME>
WHERE <COL_NAME>=<CONDITION>

Answer / amit bhagat

delete from table where col_name=value

Answer / sriramya

delete table_name where col_name=value;

Answer / vishwajeet chaudhary

delete table_name where row_no=1

Explain the use of owner option in exp command.

0 Answers  

What is materialized view in Oracle?

0 Answers   MCN Solutions,

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

What to do if the binary spfile is wrong for the default instance?

0 Answers  

What is the dynamic sql in oracle?

0 Answers  

How to convert characters to times in oracle?

0 Answers  

What is ASM (Automatic Storage Management) in Oracle?

0 Answers   MCN Solutions,

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

What is a trigger oracle?

0 Answers  

What is the data pump export utility?

0 Answers