Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you update data in a database?

User_A501PJan 19 2023

To update data in a database, you can use the SQL update statement. The basic syntax for an update statement is as follows:
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE some_column = some_value to best protective gear for skateboarding
table_name is the name of the table that you want to update.
SET clause specifies the new values for the columns that you want to update.
WHERE clause is used to specify which rows should be updated. If you omit the WHERE clause, all rows in the table will be updated.

Comments
Post Details
Added on Jan 19 2023
0 comments
260 views