Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Understanding SQL DML Statements

By: FYIcenter.com

A collection of 15 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting, updating and deleting rows from database tables. Topics included in this FAQ are:

  1. What Are DML Statements?
  2. How To Create a Testing Table?
  3. How To Set Up SQL*Plus Output Format?
  4. How To Insert a New Row into a Table?
  5. How To Specify Default Values in INSERT Statement?
  6. How To Omit Columns with Default Values in INSERT Statement?
  7. How To Insert Multiple Rows with One INSERT Statement?
  8. How To Update Values in a Table?
  9. How To Update Values on Multiple Rows?
  10. How To Use Existing Values in UPDATE Statements?
  11. How To Use Values from Other Tables in UPDATE Statements?
  12. What Happens If the UPDATE Subquery Returns Multiple Rows?
  13. How To Delete an Existing Row from a Table?
  14. How To Delete Multiple Rows from a Table?
  15. How To Delete All Rows from a Table?

Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server.

Some sample scripts requires database tables created by other samples in the beginning of the collection.

(Continued on next topic...)

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...