Search Database SQL / Scripts

  Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

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

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


   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:/','http:/') where DEPT='Marketing'

   Like      Feedback     replace string  dml  update column  replace

Subscribe to Java News and Posts. Get latest updates and posts on Java from
Enter your email address:
Delivered by FeedBurner