Solaris
bash script with sql to get the number of records from multiple tables.
Feb 10th
bash script with sql to get the number of records from multiple tables.
Hot:
Here is the bash script:
#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed -n ‘/COUNT/,/Disconnected/p’|sed ‘/COUNT/ d’|sed ‘/—/ d’|sed ‘/Disconnected/ d’|tr ‘n’ ‘ ‘ )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf ” ”
done
echo “${names[$j]} : $i”
# echo $j
let j=j+1
done
echo
echo
More >
Sharevar el = document.getElementById('share-link-549716769');el.params = {title: 'bash script with sql to get the number [...]
Related Websites
Related Websites - Using the Create Names From Selection dialog box You may have a worksheet that contains text that you...
- 3 Techniques for Memorizing Scripts - Part 3 These methods require too much mental effort for me. Memorizing...
More solaris commands
Jan 27th
More solaris commands
Hot:
These commands are taken from various sources and are quite helpful for day to day work on solaris.
For find n grep
grep -i m_forwardingProxy `find . -name \*cpp`
grep -i XVarBind `find . -name \*h`
grep -i gSLEncodeMode `find . -name “*.cpp” -o -name “*.h”`
Find:
find . \( -name “*.cpp” -o -name “*.h” -o -name “*.c” -o -name “*.cc” [...]
Related Websites
Related Websites - Musician Profile For Mark O'Connor Mark O' Connor was born and brought up in Seattle,...
- Boring But Entirely Necessary Use Offsite Data Backup in the UK Protect Your Important Data From Disaster We all have insurance...
Determine what process is listening on a port on Solaris, without lsof
Jan 14th
Determine what process is listening on a port on Solaris, without lsof
Hot:
Image by Metsuke iLife via Flickr
More >
Sharevar el = document.getElementById('share-link-89693033');el.params = {title: 'Determine what process is listening on a port on Solaris, without lsof', link: 'http://blog.amit-agarwal.co.in/2010/01/14/determine-what-process-is-listening-on-a-port-on-solaris-without-lsof/', skin: 'blue', content: 'http://blog.amit-agarwal.co.in/?ibsa=get_content&id=1492'};































