Recent content by stevecal

Eclipse also has Ruby plug-ins.

We could probably squeeze a little bit more performance out of the system by generating empty tables from a sql script prior to the customer first accessing the system. We have looked at it and while it represents a hit, at the moment the (performance hit) : (effort required to modify this...

Actually, no it doesn't. We have volume (billing) data being generated for rapid (web) deployment and display, for which we have a number of dynamically created tables on a per account basis. These bill tables contain (potentially) large amounts of data (megabytes worth in some instances), and...

Hi, I am working on a database which potentially has a large number of tables. While I appreciate that Oracle theoretically supports an unlimited number of tables within a database, are there any known major impacts on performance or should I be looking to find ways to coalesce some of the data...

I should have said that I am using MS Outlook 97 on a Windows NT platform....

I have had a really strange thing and wonder whether anyone else has seen it where I have clicked "Reply To" in response to an email and it has generated a "Reply to All". Anyone else seen this?

int sum = sumOfInts(testArray); in your main is an argument short of a full set: it needs to conform to your method prototype: public static int sumOfInts(int[] array, int index) and have an index passed to it as an arg.

And if you want a Java SNMP stack & agent framework: http://i31www.ira.uka.de/~sd/mgmt/jmgmt/ should do the trick...

Don't know what ver. of PB you're using and I haven't done anything in anger with it for quite a while but if push comes to shove you could always run a shell command and pipe ipconfig to a file and read out of the file.

http://edge.mcs.drexel.edu/GICL/people/sevy/snmp/snmp_package.html has what you need. Basic SNMP 1 & 2 support.

thread269-395909 cover most of your bases for you...

I have a syb 11 db to look at tomorrow. I'd like to export a couple of the tables' contents to ascii for a trial upload to an Oracle db. What's the best way to do it? Help appreciated.

It depends. If you need it to run from external it depends on your operating system: with Linux/unix variants you'll use cron; with NT you'll use the AT command. Alternately you can use the Oracle internal dbms_job package to run timed jobs for you.

Yes, just have a simple table with values 1 - 7 in one column and the days in another column and select as necessary. This is an easy fix to that; what I suspect you really would like to do is get a day of the week for a given date, and this is how you do that: declare v_dow VARCHAR2(12); --...

I had some fun and games last night in moving data between user functions which are arrays. There is no way of returning an array as a result of a function call. However you can use arrays by declaring your arrays as global at the top of your program; the values can then be accessed in any...