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