Title: RE: UNIX : script help/input
XOR that gives me some painful memories in recent days ... xor is possible in pl/sql but needs a little work. I migrated a C encryption code to pl/sql and then use utl_tcp to sent it to our router which feeds the modem banks.
This is how I worked
Note:
This message is for the named person's use only. It may
contain confidential, proprietary or legally privileged
information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message in
error, please immediately delete it and all
Johan:
Please see the attachment file, which is my script for everyday web
server log file and uses nslookup to process the results. Hope that it
is helpful.
Don
Johan Muller wrote:
Anybody with a quick and dirty (elegant would be nice too), to munge
output from a nslookup output file to a
]
Sent by: [EMAIL PROTECTED]
10/02/2003 05:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: UNIX : script help/input
XOR that gives me some painful memories in recent days ... xor is possible in pl/sql
unfortunately we _had_ to do it in pl/sql ... it is part of the encrypted
feed that we send out to our clients ... it is decoded by a
chip.
Oh
well I am back to array of references ...
Raj
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday,
[EMAIL PROTECTED] wrote:
Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.
Jared, what Oracle edition do you use? I'm asking because you might
want to consider not to use 'handy-dandy' hex/oct/bin/dec converter
package, but
Jamadagni, Rajendra wrote:
unfortunately we _had_ to do it in pl/sql ... it is part of the
encrypted feed that we send out to our clients ... it is decoded by a chip.
Oh well I am back to array of references ...
I'd suggest to consider external C function -- it's faster, it's
easier to
Title: RE: UNIX : script help/input
it was actually C code ... but because data is going on a modem, the pl/sql speed is acceptable (in fact we have to _wait_ after sending out each message). Had fun doing that though ... it is critical, tied to our SLA ... so must be up all the time. I'd
-L [EMAIL PROTECTED]
cc:
Subject:Re: UNIX : script help/input
[EMAIL PROTECTED] wrote:
Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.
Jared, what Oracle edition do you use? I'm asking because you might
want
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: UNIX : script help/input
Jamadagni, Rajendra wrote:
unfortunately we _had_ to do it in pl/sql ... it is part of the
encrypted feed that we send out to our clients ... it is decoded by a chip.
Oh well I am back
Anybody with a quick and dirty (elegant would be
nice too), to munge output from a nslookup output
file to a delimited file?
'File content:
Server: dns1.mci.com
Address: 199.249.19.1
Name:WCOM-4NXZGAPWY5.mcilink.com
Address: 166.50.73.209
Delimited file should have the following
I supposed if you send to a file, we can read it using ORACLE to parse
it w/plsql and then using utl_file write it back out but seems like
overkill to use oracle for that, but then again this is an oracle list,
so i'll have to assume thats what you wanted, anyone up for the task :)
joe
Johan
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
@LB=split /\s+/;
if ($LB[0] =~ /^name:/i) {
$NAME=$LB[1];
}
if ($LB[0] =~ /^address:/i) {
$IP=$LB[1];
write;
}
}
format STDOUT=
@ ,@
$NAME,$IP
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~
On Wed, 2003-10-01 at 13:24, Johan Muller wrote:
Mladen,
It worked!
Did you have any doubts? That's precisely what perl is good for.
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From:
Johan Muller
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 8:24
PM
Subject: Re: UNIX : script
help/input
Mladen,
It worked!
Heartfelt thank you
-LSubject:
Re: UNIX : script help/input
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From:
Johan
Muller
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 8:24
PM
Subject: Re: UNIX : script
help
:)
On Wed, 2003-10-01 at 10:24, Johan Muller wrote:
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).
Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
Thank God for Jared -Original Message-
From: Tanel PoderSent: 10/1/2003 10:37:55 AMTo: [EMAIL PROTECTED]Subject: Re: UNIX : script help/input
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From: Johan Muller
To: Multiple recipients of list ORACLE-L
On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote:
Funny .. I am currently sitting in a Perl class, so I can actually
read what MG has written. I'll be soon Perl-literate ...
Raj
Good! The more the merrier! Welcome to the club.
Note:
This message is for the named person's use only.
-
From: Johan Muller mailto:[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:24 PM
Subject: Re: UNIX : script help/input
Mladen,
It worked!
Heartfelt thank you
Good! The more the merrier! Welcome to the club.
Oh most definitely.
As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.
I finally bit the bullet and used string
Jared
Jared Still wrote:
Good! The more the merrier! Welcome to the club.
Oh most definitely.
As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.
I finally bit the
23 matches
Mail list logo