Oracle Programming/Manipulating Data

< Oracle Programming


Describing each data manipulation language (DML) statementEdit

Inserting rows into a tableEdit

Insert into [table name][column1,column2,.....] values(value1,value2,....);

Updating rows in a tableEdit

To update rows in a table, write : update [table name] set [column name] = [your value];

It will update all the rows present in the table by the given value in the selected field.

We can also add queries to this command to make a real use for example,

update [table name] set [column name] = [value] where [column name]>=[value];

You can add your query after the where clause according to your need.

Deleting rows from a tableEdit

Controlling transactionsEdit

  1. Save and discard changes with the COMMIT and ROLLBACK statements
  2. Explain read consistency