Posts Tagged ‘SQL’

Oracle 11g – Password expires

Posted: 10th June 2013 by Babar Shafiq in System Administration
Tags: , , , ,

  Oracle 11g sets by default password expiration. The expired message needs to re-login and reset the old password to new one. Suppose you have an user with the status “expired”: You can check that by:

MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace a text string which affects many records or rows, such as change of company name, postcode, URL or […]