Oracle's sqlplus has a rich set of commands that can format your results in a large number of ways, thereby rendering "sed" or "grep" or "egrep" useless.
If you use these sqlplus commands, you don't have to do extraneous processing using Unix utilities. And you don't have to create and remove temporary files either.
Here's a short script that illustrates their usage:
And here's the Bash shell script and its execution:
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Hi
I need to calculate the number of occurrences of a item in a number of files using Perl.
The item appears continually throughout the files but in each case I only want to calculate it in certain blocks of the file.
Example - Calculalte the number of occurrences of a 'pass' in a block of... (0 Replies)
Hi ,
I have input file and i want to extract below strings
<msisdn xmlns="">0492001956</ msisdn> => numaber inside brackets
<resCode>3000</resCode> => 3000 needs to be extracted
<resMessage>Request time
getBalances_PSM.c(37): d out</resMessage></ns2:getBalancesResponse> => the word... (14 Replies)
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Hi All,
I have a huge matrix file consisting some some millions rows and 6000 columns. The contents are just floating point numbers in the matrix. I want to extract each column (i.e. 6000 of them) and store each column in a separate file.
For example, 1.dat will consist of elements from column... (4 Replies)
Hi,
I have one file, say file 1, that has data like below where 19900107 is the date,
19900107 12 144 129 0.7380047
19900108 12 168 129 0.3149017
19900109 12 192 129 3.2766666E-02
... (3 Replies)
I am trying to compare the data in lines 3 & 5 to see if they match up to the '-S570' (see first code set, all proprietary information has been removed from code set)
spawn telnet
Trying ...
Connected to CA-LOS1234-ASE-S570.cl .
Escape character is '^]'.
CA-LOS1234-ASE-S570
Username: ... (1 Reply)
HI
I have a dsv file that looks like:
<<BOF>>
record_number|id_number|first name|last name|msisdn|network|points|card number|gender
312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M
313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Discussion started by: tera
4 Replies
LEARN ABOUT DEBIAN
collectd-email
COLLECTD-EMAIL(5) collectd COLLECTD-EMAIL(5)NAME
collectd-email - Documentation of collectd's "email plugin"
SYNOPSIS
# See collectd.conf(5)
LoadPlugin email
# ...
<Plugin email>
SocketGroup "collectd"
SocketPerms "0770"
MaxConns 5
</Plugin>
DESCRIPTION
The "email plugin" opens an UNIX-socket over which one can submit email statistics, such as the number of "ham", "spam", "virus", etc.
mails received/handled, spam scores and matched spam checks.
This plugin is intended to be used with the Mail::SpamAssassin::Plugin::Collectd SpamAssassin-plugin which is included in contrib/, but is
of course not limited to that use.
OPERATION
This plugin collects data indirectly by providing a UNIX-socket that external programs can connect to. A simple line based protocol is used
to communicate with the plugin:
o E-Mail type (e.g. "ham", "spam", "virus", ...) and size (bytes):
e:<type>:<size>
If "size" is less than or equal to zero, "size" is ignored.
o Spam score:
s:<value>
o Successful spam checks (e.g. "BAYES_99", "SUBJECT_DRUG_GAP_C", ...):
c:<type1>[,<type2>,...]
Each line is limited to 256 characters (including the newline character). Longer lines will be ignored.
SEE ALSO collectd(1), collectd.conf(5)AUTHOR
The "email plugin" has been written by Sebastian Harl <sh at tokkee.org>.
The SpamAssassin-plugin has been written by Alexander Wirt <formorer at formorer.de>.
This manpage has been written by Florian Forster <octo at verplant.org>.
5.1.0 2012-04-02 COLLECTD-EMAIL(5)