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

Explain the use of compress option in exp command.

0 Answers  


How many anonymous blocks can be defined?

0 Answers  


How to create a stored function in oracle?

0 Answers  


after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  


What is clusters ?

2 Answers  


What does sharding mean?

0 Answers  


Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  


How to export several tables together?

0 Answers  


What is the maximum number of triggers that can be applied to a single table?

0 Answers  


How to experiment a data lock in oracle?

0 Answers  


26. Display the earliest shipping date in the format: DD/MON/YYYY

5 Answers   Wipro,


What is the simplest tool to run commands on oracle servers?

0 Answers  


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)