Oracle Update table

Change the data in a table: 1, update a specific row;

2. Update all rows.

Note: When updating, be sure to add a where condition, otherwise update all row data in the table.

Format: Update a specific line: Updates table

Set table_xxx= ' aaaaaa '

where table_id= ' BB ';

Update multiple rows: Update table

Set table_xxx= ' aaaaaa ',

Table_city= ' CC ',

......

Table_name= ' DD '

where table_id= ' BB ';

Example: Update Customers

Set cust_email= ' [email protected] '

Where Cust_name= ' Yang '

To delete the value of a column in a table, set it to null (assuming that the table definition allows null values).

Update customers set cust_email= ' null ' where cust_name= ' yang '

Null is used to remove the value from the Cust_email column, and null indicates no value. And the string ' ' represents a value.

This article is from the "if you are in full bloom" blog, please be sure to keep this source http://yangyadong.blog.51cto.com/3537462/1919849

Oracle Update table