Update: Update A Specific Record

Description: Updating a single record in a single table.

UPDATE <table_name>
SET <column_name> = <value>
WHERE <column_name> = <value>
 
SELECT DISTINCT object_name
FROM my_table;
 
UPDATE my_table
SET object_name = 'LOAD'
WHERE object_name = 'DUAL';
 
COMMIT;
 
SELECT DISTINCT object_name
FROM my_table

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.