archives

Varchar2

Hi, I'm looking around for opinions. We're running Oracle 10g, we have the need now for a VARCHAR2 column with 6000 characters. I know the standard thing is to create a LOB column. We have not LOB column in our database. I have 2 options here: The first is to create 2 columns, and, use a function on SELECT and a

FAQ 4.54 Why does defined() return true on empty arrays and hashes?

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] .

Help: Which Grid Control should I use?

Dear group, I have some oracle 9208 databases on windows(32bit), some oracle 10.2.0.1 database on linux(32 bit) and our new database is Oracle 10.2.03 on Linux(64 bit). My question is, 1) do I have to use Oracle grid control 64 bit, or it does not matter? 2) for the agent for the client, should it be 32 bit or 64 bit? shold

FAQ 4.50 How do I select a random element from an array?

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] .

FAQ 4.60 How can I always keep my hash sorted?

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] .

Tecnique and/or Modules for Perl and HTML

Greetings, Could someone point me in the right direction? I'm not a web developer - just a budding perl dude (who's really a database guy). I'd like to (at first) read from database (using DBI) and display the contents on a web page. The trick is I want to do it on the same page that the action button resides and pop the output of the perl program

Oracle and Ruby

Hello, Anyone using Oracle with Ruby ? I did some tests using ruby-oci8 and it appears that it's 2-3 times slower than SQL*Plus or Perl. I wrote a script which dumps 500.000 records of a big table into a comma separated flat file. Oracle server and client are version 10.2.0.3.0. So I wonder why Ruby is so slow ?

FAQ 4.57 How do I look up a hash element by value?

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] .

A question about multithreading

I managed to get my threading script to work, to a point. I can launch an arbitrary number of threads, and have them run concurrently. But the processor is not being fully exploited. If I launch ONE child process in one thread, one of the four available cores is nearly fully utilized (about 95% of that one core's cycles.

Installing Oracle

You know, this is why developers should never be given access to the server. We are running ORacle 10g. We were going to drop a database and recreate it on our development box. Rather, a developer deleted all of the datafiles AND the software. I'm here at home with an SSH connection to work. Can I download the

use CGI::Carp qw(fatalsToBrowser) not sending file handle errors to browser

I wrote the following script to test whether, if I try writing to an invalid filehandle, the error message would get sent to the browser: use strict; use IO::File; use CGI::Carp qw(fatalsToBrowser); print "Content-type: text/html\n\n"; nobody my $fh = IO::File->new("> doesnotexist.txt"); print $fh "foo";