Wednesday, March 23, 2011

oracle remove unwanted character from data column 

// remove \r @ \n
update table-nama set column-name = REPLACE(REPLACE( col_name, CHR(10) ), CHR(13) )
  
// replace white space  update table-nama set column-name = REPLACE(REPLACE( col_name,' ' ), '' )
at

Centos 7 reset root/ any user lost password / lockout due to cant remember password

1. Need to be in front of the terminal. (Physically if not vm). 2. Reboot the server 3. Press 'e' in the GRUB2 boot screen. 3. bunch...