Abstract
Now that we learned how to write advanced SQL statements to retrieve data, it is time to learn how to write advanced SQL statements to change data. Oracle Data Manipulation Language (DML) lets us insert, update, and delete data.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
Arguably a SELECT statement is also a DML statement, especially a SELECT FOR UPDATE that locks rows. SELECT doesn’t permanently change tables but it does manipulate data. In practice, developers treat SELECT different than other statements, so when this book says “DML,” it does not include a SELECT statement.
- 2.
If you’re interested in seeing an example of the problems key-preserved try to avoid, look at my answer to this question: https://stackoverflow.com/questions/17092560/ .
- 3.
We may be able to work around server access limitations with the open source program Oracle Copy (OCP): https://github.com/maxsatula/ocp .
- 4.
The popular DATA_DUMP.SQL is useful for quickly outputting data to a CSV file. There are many versions of this utility, including one I have worked on: https://github.com/jonheller1/data_dump .
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Jon Heller
About this chapter
Cite this chapter
Heller, J. (2019). Modify Data with Advanced DML. In: Pro Oracle SQL Development . Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4517-0_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4517-0_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4516-3
Online ISBN: 978-1-4842-4517-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books