(Oracle DB) - 17. UPDATE

/* Format of UPDATE */
UPDATE table_name
	SET
	column_name_A = value,
	column_name_B = value,
	--...
WHERE 1 = 1
	AND conditions
;


/* SELECT ex3_1 */
SELECT *
	FROM ex3_1
;


/* UPDATE Data of 'col2' to 50 */
UPDATE ex3_1
	SET col2 = 50
;	-- 5 rows updated.


/* UPDATE Null in 'col3' to Today */
UPDATE ex3_1
	SET col3 = SYSDATE
WHERE 1 = 1
AND col3 IS NULL	-- AND col3 = ''
;