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

Proxmox installation display out of range

Reference:  https://forum.proxmox.com/threads/proxmox-ve-screen-out-of-range.131297/

  • PHP Regular Expression Remove BBCODE
    How to remove BBCODE from a string ?   <?php  $String = "[b][color=#0000ff]TEST[/color][/b]"; $regex = '|[[\/\!]*?[^\[\]...
  • USB and Firewire Pinout
    Original Source:: http://www.zytrax.com/tech/pc/serial.html Tech Info - USB and Firewire USB and FireWire (IEEE 1394a and b) represent the...