Browsed by
Month: October 2015

Software: SuperPuTTY

Software: SuperPuTTY

Are you using PuTTY? Why don’t you try SuperPuTTY? Features Docking user interface allows personalized workspace and managing multiple PuTTY sessions easy Export/Import session configuration Upload files securely using the scp or sftp protocols Layouts Supports PuTTY session configurations including Private Keys Supports SSH, RLogin, Telnet and RAW protocols Supports local shell via MinTTY or puttycyg Supports KiTTY Project website SuperPuTTY

PL/SQL: Multiply rows

PL/SQL: Multiply rows

Sometimes we need to insert to the database data that is only slightly different than currently existing data set. For example: we have table called network_elements with column software_version. We want to add new software_version for all current rows and also keep existing ones. The idea is we want to copy all rows with software_version=1.0 but modify field software_version to 2.0.

 

Oracle: tablespace size

Oracle: tablespace size

Tablespace size and freespace can be checked with a following query: