Oracle Programming/Manipulating Data
From Wikibooks, open books for an open world
Contents |
[edit] Describing each data manipulation language (DML) statement
[edit] Inserting rows into a table
Insert into [table name][column1,column2,.....] values(value1,value2,....);
[edit] Updating rows in a table
[edit] Deleting rows from a table
[edit] Controlling transactions
- Save and discard changes with the COMMIT and ROLLBACK statements
- Explain read consistency
