Database SQL / Scripts for '#DML'

Database SQL / Scripts for '#DML' - 3 Query/Script(s) found

Sample 1. Update all records / rows of a Date column to System Date

UPDATE TABLE_NAME SET COLUMN_NAME = SYSDATE;

_{Like Feedback Update Update Statement DML SysDate}

Sample 2. Update a column (COLUMN1) value to 'abc' for all records having the value of 'xyz' in another column (COLUMN2)

update TABLE_NAME set COLUMN1 = 'abc' where COLUMN2 = 'xyz'

_{Like Feedback update table update column DML}

Sample 3. Replace a String in a particular column of Table

update EMPLOYEE set PROFILE_URL = replace(PROFILE_URL,'http:/xyz.com','http:/abc.com') where DEPT='Marketing'

_{Like Feedback replace string dml update column replace}

Search Database SQL / Scripts