Data Conversion

Maybe I'm a moron. I don't know, but I can't even get Hello World to work in Oracle. I have the following SQL file: BEGIN DBMS_OUTPUT.put_line ('Hello World'); END; I am using SQL developer and connecting to an Oracle Server instance (not sure what version). I run the above file and it just says

Hi guys. ANother quick question. I have the following sql file: DECLARE CURSOR cursor1 is SELECT * FROM tblName1 WHERE tblName1.ald="id"; BEGIN FETCH cursor1 BULK COLLECT INTO tblName2 LIMIT 10; END; When I try to run the script, I get the following error: ORA-06550: line 7, column : PLS-00403: expression 'TBLNAME2' cannot be used as an INTO-target of a

This is an excerpt from the latest version perlfaq5.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 was trying to write an auto responder on a local BBS. However, when I have perl send the BBS respond command to the BBS, I get "Input not a tty". I'm assuming this is because of the BBS text editor that sits on top of the BBS or what not. m-net% more post.pl use strict; use warnings; open my $out, ' -', 'bbs'

I have function which I'd like to call telling it how to sort some arrays. I'd like to do something like: my $sort_by_x_ref = sub { return ($x{$b} <=> $x{$a})}; my $sort_by_y_ref = sub { return ($y{$b} <=> $y{$a})} sub print_sorted { my $sort_function = $_[0]->(); print "Sorted $_[1]\n"; foreach (sort {$sort_function} keys %some_array) {

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

Why did ETL tools come about? What triggered them? What was the catalyst? These questions may decide the outcome of the biggest ETL patent trail of them all.

Hello, The query below (names changed so I don't give away too many company secrets!!) works fine unless you uncomment the line 'AND mp.id = 5010000' when an 'end-of-file on communication channel' error occurs. SELECT mp.ID AS ID, mp.a2 AS a2, mp.a3 AS a3, SUM(nvl(ocp.b1,0)) b1, SUM(nvl(ocp.b2,0)) b2,

Finally started rendering some of the video from my house concert in Chicago. I opened with a song I wrote back in 1990 or thereabouts.  Might actually have been about 1993. True to form, first song, first set, I messed up and almost sang the second verse a second time... That's okay, Richard Shindell forgets lyrics sometimes too.  He repeats a

LewisC's An Expert's Guide To Oracle Technology In the first part of this series, I talked about Vertica the company and how Vertica is

LewisC's An Expert's Guide To Oracle Technology In the first part of this series, I talked about Vertica the company and how Vertica is

This is an excerpt from the latest version perlfaq5.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! Do you know how to create a reference to an element of an array or hash? For instance I have an array @a, and I like $a2r contains a reference to $a[2]. Anyway to do it in perl? Keep in mind this is not the case where $a[2] contain a reference and $a2r contains the same reference, but instead $a2r

I think this is close, but I don't quite understand this well enough to build the expression I need to build. It is something I ran across in existing code, need to modify, but have had no prior experience doing. I found and have been using the following documentation to help me experiment. [link]

County of Ventura Selects Anacomp for Document Conversion Services

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

This a blog post that could be summarised with the following quote from the article that it references: "Learn what works. Try out lots of things. And then go with what you end up liking. No harm. No foul" (By Chris Brogan) Collaboration, Communities,

McKinney Courier Gazette

HearWho Converts Text to MP3 Lifehacker Australia, Australia - Aug 5, 2008

Say I have this program call go.pl A B C.gz D.bz2 I'd like to just use <> in go.pl and have the compressed files automatically extracted. Is there a way to do that without writing my own logic, as a module I can bring in? This is a read-only task. I couldn't find anything on CPAN. Thanks Ted