Remove Comma from Column in Oracle

Remove Comma Character from Column -- Use the below sql query, which will remove , from the string UPDATE data_dict SET src_value = regexp_replace(src_value,'\,+',''); -- Use the below sql query, which will remove . from the string UPDATE data_dict SET src_value = regexp_replace(src_value,'\.+','');

Running SQL Script for Multiple Databases SQL*PLUS | Mutiple Servers SQL*PLUS in Shell Script | BASH Script Looping SQL*PLUS commands

For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1. Oracle client should be installed on the Unix/Linux Server 2. Create Local TNS entry in the tnsnames.ora file for the databases where you will run the commands 3. All databases should have one common user … Continue reading Running SQL Script for Multiple Databases SQL*PLUS | Mutiple Servers SQL*PLUS in Shell Script | BASH Script Looping SQL*PLUS commands

Top command AIX

AIX doesn't have a top command what it has a better tool called topas. Just write topas from a shell prompt and it opens a beautiful colored stats window where you can get the top consuming sessions as well as few other useful information. # topas