archives | Data Conversion

archives

FAQ 1.10 Can I do [task] in Perl?

This is an excerpt from the latest version perlfaq1.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

create two database

Hi guys, I created two database but I have some problem : 1.How I can startup two data base or one of them ? 2.After create second database the listener is point on first data base ,How I can start listener for second database ? 3.Can not login to second database? Thanks

Trasaction between procedure calls.

Problem Statement: I’ve written a Stored Procedure which has several insert statements. After inserting these statements ,its calling other stored procedure which again has some insert statements. Now if the second procedure has some error, everything should be rolled back. The skeleton of the procedure is as follows.

LIKE operator on CHAR column when there is no wildcard character

We are trying to upgrade our database from Oracle 9i to 10g. We have a CHAR(30) column in a table. When we perform string comparisons using '=' operator (Eg.....where col = 'XYZ' ) the trailing spaces are ignored, which is perfectly fine (both in 9i & 10g). When we use LIKE operator without specifying any wildcard char in

FAQ 1.4 What are Perl 4, Perl 5, or Perl 6?

This is an excerpt from the latest version perlfaq1.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Re: Elisp Lesson on file processing (make downloadable copy of a website)

In this week i wrote a emacs program and tutorial that does archiving a website for offline reading. (See [link] ) In the process, i ran into a problem with the unix “cp” utility. I've been a unix admin for Solaris during 1998-2004. Even the first time i

FAQ 4.10 Why aren't my random numbers random?

This is an excerpt from the latest version perlfaq4.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Want regex s/// to replace only nth occurrence

my $s = "The sneaky cat sneaked sneakily." ; I would like a simple s/// statement which would replace only the $nth occurrence of "sneak". ($n is a variable). Can't find the answer. Is this possible? Thanks, Jerry Krinock

Authen::Captcha - How do I make it display the image

Hi, My PERL is VERU rusty. Not used in years and have to now implement a CAPTCHA on an old project because of high levels of form SPAM. This is my code so far: *************** use strict; use warnings; use Authen::Captcha; print "Content-type: text/html", "\n\n"; my $captcha = Authen::Captcha->new(

Bot::BasicBot's forkit() creating zombies

Hello all. First of all I'd like to tell you all that I'm a total Perl newbie, just have read the excellent and fun "Learning Perl" and a bit of "Programming Perl" in finnish... I have created an IRC bot based on Bot::BasicBot, but when I use the Bot::BasicBot's forkit() method to run for example a Yahoo! search in

Trip to Boeblingen to Present at "Web 2.0 and System z" & "See the Light"

And here we go on the road again! This time around to Germany, more specifically to Böblingen where I will be presenting at two different events on "See the Light - Thinking out of the Inbox". One of them part of a series most folks are already familiar with, the other one just as interesting as it would approach me quite a bit to Hardware 2.0! Can't wait! Arriving there tomorrow afternoon!

Differences in BULK COLLECT between 9i and 10g?

Oracle 9i 9.2.0.1.0, Windows XP Pro In playing around with the 9i on my desktop I've come across something which has me a bit baffled. In the first code segment I have a cursor where I return a row based on a database table. I then BULK COLLECT into the nested table which is defined on the database table. This

How best to take a copy of a variable and edit it with s///?

I frequently have the need to take copy of a variable and edit it (for printing or some such). I code it like this: my $ugly_variable = some_function(); # Or read from a file maybe my $nice_variable = $ugly_variable; # Take a copy ... $nice_variable =~ s/nasty/nice/g; # ... and then make it look nice

And ... the King of Clay Won!

Yes, I know what I am about to post hasn't got anything to do with the main topics discussed over here, in this blog, but I just can't help myself and hope you can understand my excitement. After watching one of the most incredible tennis matches in history; one of those matches where both opponents raise to the occasion of becoming a fight of titans; one of those matches that surely dignifies tennis

H_q!o Innocent or Gullable? H_q!o

Must Read Book: "Will The Next Liar Please Stand Up" [link] %`+HjPHq;`.3#c1

Enterprise manager is Not Connecting to database

Hi I installed oracle 10g on my system the installation was successfull but in the enterprise manager console 1.database instance is down 2.Listener is up and running 3.Agent Connection to Instance Status Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)