delete from table where col

How to remove a row in a database table?

Question Posted / amit bhagat

Answer Posted / amit bhagat

delete from table where col_name=value

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the restrictions in a oracle read only transaction?

1026

What is a server parameter file in oracle?

1047

How to specify default values in insert statement using oracle?

1097

Is there an oracle sql query that aggregates multiple rows into one row?

968

How to export several tables together?

1045

Explain the function of optimizer in oracle?

1126

How to view all columns in an existing table?

931

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4563

Explain the use of compress option in exp command.

1015

How to recover a dropped table in oracle?

1033

How can we view last record added to a table?

1033

What is oracle server autotrace in oracle?

1157

Explain the use of indexes option in imp command.

1166

How are extents allocated to a segment?

1118

Can you assign multiple query result rows to a variable?

982