How to remove a row in a database table?

Answer Posted / amit bhagat

delete from table where col_name=value

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the features of oracle?

600


Explain alias?

715


What is blob data type in oracle?

561


How to revoke create session privilege from a user in oracle?

559


How to view existing locks on the database?

553






How to pass a cursor variable to a procedure?

562


Write a trigger example in oracle?

573


why dont we assign not null constraint as table level constraint.

2256


What is an oracle transaction?

588


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?

1472


Please explain oracle data types with examples?

590


What is recovery manager(rman) backup in Oracle?

629


Name the various constraints used in oracle?

566


How to create a table index in oracle?

662


How index is implemented in oracle database?

596