Data Conversion

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

I am using Perl 5.8 with the DBI module to routinely send parsed data to an Access db. Sometimes the incoming files may have errors so that numeric data appears as text. This causes my script to throw a warning: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. (SQL-22018) at C:\myscript.pl line 422.

On a HP-UX machine running Oracle Enterprize 9208 This query (has been simplified) select a,b from t1 where (a,b) not in ( -- select * from ( select a,b from t1 where a in (1,2) -- ) ); returns a different number of rows to this query select a,b from t1 where (a,b) not in ( select * from (

This week my tutorial is on PHASE 4 of the "PRIDE"-ENTERPRISE ENGINEERING METHODOLOGY (EEM) - ENTERPRISE INFO STRATEGY, Part VI of our series on the "PRIDE" METHODOLOGIES FOR IRM (special broadcast). My "Pet Peeve of the Week" is "The SFB Quotient" and we also have our "Letters to the Editor."

My Pet Peeve of the Week is "The SFB Quotient."

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

Hi , is it possible to use global variables in oracle? and is there any way to control concurrency on this memory variable? i can use a table, and read this by using for update. Under heavy loads, this will create contention. what else can i do? i try to use sequence data variable. there are multiple sessions.

Hi, I need to store java objects in my oracle database. These objects have serveral fields, e.g. Object1: String f1; String f2; Date f3 Object1: String f1; BigDecimal f2; Boolean f3 e.g. Object1("Hello", "World", 2008-09-05) Object2("Foo", 100.20, true) The database shall scale up at least to 100 million objects.

I was surprised to read a research report that listed IBM as a "Challenger" in data migration software since they usually show up in data integration reports as a leader.

Mechanical CAD Software delivers 3D solid parametric modeling. ThomasNet Industrial News Room, NY - 16 hours ago

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

Hi, is it possible to use HTTP BASIC AUTH with an URL_DATASTORE? If so, which attributes I have to set? I only found this example: begin ctx_ddl.create_preference('my_ url','URL_DATASTORE'); ctx_ddl.set_attribute('my_url' ,'HTTP_PROXY','www-proxy.us.or acle.com'); ctx_ddl.set_attribute('my_url' ,'NO_PROXY','us.oracle.com');

Hi, when gets a text index type CONTEXT updated? Like every other index on insert/update/delete or only when I call create index? Thank you

Wixi Announces Launch of Public Beta MarketWatch - 12 hours ago

I was driving by and saw this guy. I had to stop and film him.  Realize, it is about 107 out and he was working!!! Sorry about the low resolution...

Hello I am trying to kill the jobs that I see on DBA_DATAPUMP_JOBS (Oracle 10g R1) select * from DBA_DATAPUMP_JOBS OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS SYS PHR_EXPORT2 EXPORT TABLE NOT RUNNING 0 0 SYS PHR_EXPORT EXPORT TABLE NOT RUNNING 0 0 SYS PHR_EXPORT1 EXPORT TABLE NOT RUNNING 0 0

Hi and TIA. Following is a snippet of code which uses HTML::TableContentParser to pull table data out of an HTML page. I've gotten it to work, but, I'd like to better understand why/how (particularly the long array/hash references). I've read the Perllol and Perlref documents, but would really appreciate a plain language walk-through. Thanks.

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

I am creating a website. The website root is /www at server. my file ContactUs.html is kept in /www FormMail.pl is kept in /www/cgi-bin It was downloaded from [link] No changes done. .FormMail.conf is also at /www When I click submit, instead of displaying thanks.html (in the same

Eddie Bauer Announces Consent Solicitation for Its 5.25 ...