How to remove a row in a database table?

Answer Posted / malini paul

delete from <tablename> where <condition>;

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a query with a left outer join in oracle?

607


What is difference between truncate and delete?

566


When do you get a .pll extension in oracle? Explain its importance

576


Can the query output be sorted by multiple columns in oracle?

574


How to change program global area (pga) in oracle?

591






What is the quickest way to export a table to a flat file?

577


What is a private synonym?

1088


What is an oracle function?

602


Can we convert a date to char in oracle and if so, what would be the syntax?

552


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1490


How do we create privileges in oracle?

588


How to display row numbers with the records?

588


What is a cursor and what are the steps need to be taken?

603


What is tns name?

547


What are the parameters that we can pass through a stored procedure?

559