Search results for query: *

I would like to use a single prepared statement (JDBC). For example: SELECT NAME WHERE REGION = ? AND SITE = ? The issue is that the region and site qualifiers are optional. Is there a way that I could set the region/site values to a wildcard, so that they don't get used?

Also, keep in mind that there are various editions of Oracle. You may not need the enterprise edition.

I'm not using any connection pool. I'm just at the planning stage right now. I'm trying to either write my own static class to handle connections, or use an already built framework.

I'm trying to figure out how to set up a connection pool class using the Oracle thin driver. Any guidance or tutorials would be greatly appreciated. Thanks!

Basically I would like to be able to specify a string length and generate a random string value. EX: string length = 7 output: fwirvbt I presume that I would use the rand() function, but I'm not sure how i would use it to generate character values. Thanks!

Ok, i need to include a .pm file in the current working directory (not from the perl module directories). So what would be the syntax to use?

Ok, So i'm using Solaris 9 with Oracle 9.2 I accidently wiped out everything in my /u03 directory which contained to redo log and the control file. Can anyone point me in the right direction as to what I need to do?

I'd like to overwrite line 234 of a text file with a specific string. What is the easiest way to do this? Would i use sed?

I'd like to access a file and replace every instance of "TERM=sun" to "TERM=vt100". Normally i would just use the code sed -e 's/TERM=sun/vt100/' file But unfortunately, larger words also match. (For example "TERM=sun-color" gets changed to "TERM=vt100-color") How would i force it so that...

I need to be able access a text file (about 20 lines) and basically just replace the first line with custom text without changing anything else. What is the best way to do this? (I understand that this would be much easier to do in Perl, but I don't have that option)

The current way of installing OVO is to run the ovoinstall program which brings up a graphical wizard asking the user a long series of questions. I was wondering if there is a way to do a non-graphical install which could be scripted (automated) to save time when installing. [Runinning...

Is there any utility or commonly used program for automatically mounting CDs when they are inserted? (Similar to what Solaris does?)

I'm trying to store the date as a variable in the format dd-mm-yy. (Similar to date '+%m-%d-%y' in UNIX.) Unfortunately when i use the localtime module it doesn't return the single digit days and months with a preceding zero. (1-3-05 instead of 01-03-05) Is there a simple workaround...

I was wondering what symbol/syntax to use that would represent any type of whitespace. Basically i need to split each of the words in a string into seperate array elements. The only issue is that the words are seperated by an undefined amount of spaces or tabs. @data = split (/ /, $_); #...

I was wondering what the best way is to call a perl program from within another perl program. I basically just want to execute it and test whether it was succesful or returned an error code.

What would be the best way to remove the first two characters from the begining of a string (or extract the last two characters)? In this case 2004 -> 04

What about the situation where the exact path already exists, so it shouldn't create anything? How would mkpath handle that? Basically I'm looking to for the same functionality as mkdir -p in a shell script.

The alarm fucntion sounds very interesting, (especially since I'm using ksh). I read the man page, but I'm still kind of confused as to how to use it. Any tips?

I'm trying to write some sort of function so that if too much time goes by (20 seconds) the script will break and exit. But i'm not sure about the best way to do that.

What would be the best way to throw in an exception where if telnet can't connect to the machine within 15 seconds, it breaks and returns an exit code?