archives

FAQ 7.18 How can I access a dynamic variable while a similarly named lexical is in scope?

This is an excerpt from the latest version perlfaq7.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] .

cpan link not stuck to a version

I want to make a link the Win32::Shortcut web page on CPAN to put into [link] , but [link] or [link] have the version hardwired in them: my link will stale soon. But

Problem with Eval in Constructing AoA

Hi, This code below tries to convert the string in newick format into the corresponding data structure (Array of Array). But somehow the EVAL function doesn't work as expected. What's wrong with my code here? __BEGIN__ use Data::Dumper; use Carp; my $str = "(foo,(bar,qux))"; #Newick format print "$str\n";

FAQ 7.29 How can I use a variable as a variable name?

This is an excerpt from the latest version perlfaq7.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] .

optimizing mass inserts and updates

Hi, I'm converting data from Oracle7 to Oracle10 and the tables and the data change a lot. The main conversion is done by insert-select (dynamic plsql) from imported old tables and that works fine and pretty fast even for big tables (more than 1 million rows), but extra upates that are often needed are a little bit slow. So I'm wondering how to speed them up. I'm going to

FAQ 7.11 How do I create a class?

This is an excerpt from the latest version perlfaq7.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] .

TRIGGER

HI EVERYBODY i have this trigger : CREATE OR REPLACE TRIGGER FORMASGC.TR_CAMB_EST_CHEQUE after insert or update of cod_status_cheque or delete ON FORMASGC.GCCB_CHEQUE for each row declare ls_new varchar2(10); ls_old varchar2(10); begin if inserting or updating then

CREDIT CARD DEPT

CREDIT CARD DEPT [link]

CREDIT CARD DEPT

CREDIT CARD DEPT [link]

How to read/write this data.

I have ten Excel files which I read with Spreadsheet::ParseExcel. Each file has only one worksheet. The worksheets are 6 columns by $sheet->MaxRow (ie, I don't know, but perl can find out). Each sheet is divided into sections of identically structured data, an empty line divides the sections. I want to access the data, so it can be output identically, but in a

Search a file

Hello Does anyone know how to find out whether a file exists or not? TIA

FAQ 7.16 How do I create a static variable?

This is an excerpt from the latest version perlfaq7.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] .

displaying clob in sqlplus/toad

Hello all, I have a client that is written using a script that inserts data into clob data fields and these columns exceed 32K. It looks like the writes to the lobs are suceeding from the client, but I am unable to view them data from either sqlplus nor toad. How would I be able to display clob fields via sqlplus or

XML::Twig doctype and entity handling

I'm writing a program that needs to extract a clump of XML metadata stored inside of a noncompliant HTML file and then perform a number of operations on that metadata. (Specifically, for those curious, this is part of a Mobipocket .prc to IPDF .epub ebook converter.) The HTML file in question has no doctype declaration, and XHTML