How to remove a row in a database table?

Answers were Sorted based on User's Feedback



How to remove a row in a database table?..

Answer / malini paul

delete from <tablename> where <condition>;

Is This Answer Correct ?    8 Yes 0 No

How to remove a row in a database table?..

Answer / chand

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

Is This Answer Correct ?    4 Yes 1 No

How to remove a row in a database table?..

Answer / amit bhagat

delete from table where col_name=value

Is This Answer Correct ?    4 Yes 1 No

How to remove a row in a database table?..

Answer / sriramya

delete table_name where col_name=value;

Is This Answer Correct ?    0 Yes 5 No

How to remove a row in a database table?..

Answer / vishwajeet chaudhary

delete table_name where row_no=1

Is This Answer Correct ?    0 Yes 9 No

Post New Answer

More Oracle General Interview Questions

How to export data to a csv file?

0 Answers  


How to load data through external tables?

0 Answers  


How to do paging with oracle?

0 Answers  


how to find out largest value in a table

2 Answers  


What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers  






What is an oracle?

0 Answers  


what is null value?

9 Answers  


what is host string in sql plus? how does it related to database?

1 Answers  


What is trigger associated with the timer ?

1 Answers   Oracle,


How to use subqueries with the in operator using oracle?

0 Answers  


Please explan Why static query is more faster than dynamic query ?

2 Answers  


4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)