Search results for query: *

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

Yes you can do it; but you need to execute this as dynamic SQL; the syntax for this will obviously differ dependant on the version of Oracle you are using.

NB: Oracle doesn't always tidy up open processes so you might want to run a Unix command like kill -9 <pid-id>. PS: You can get pid-id as follows: select vs.sid, vs.serial#, vs.status, vp.spid from v$process vp, v$session vs WHERE UPPER(vs.username) LIKE '%';

Jayaram, this might help you... Determine active/inactive sessions (and kill them…) SELECT sid,serial#,status,server FROM v$session WHERE UPPER(username) LIKE '%'; When you know the sid and serial# then you can kill them if you have sufficient privileges by passing the values of sid and...

But you can fake it by creating public synonyms for all the user's objects (you can do this with a spool script using: SELECT * FROM user.user_objects, etc), this saves you a) from prepending the username prior to the objects and b) will allow you to run packages, triggers, etc as though you...

You need to do the ref cursor TYPE inside the package header rather than the body of your proc in order to make it externally available. Presumably you are trying to make the cursor available to something like e.g. a JDBC call, in which case you do not even have to loop it, just open the cursor.