Search results for query: *

Hi We have a table which has a long field containing essentially clob (text) information. The text compresses well by zip. We'd like to compress the text, and have Oracle do this transparently on insert and select for us, ideally. Is this at all possible? The field may or may not have to...

Hi I was wondering if anyone could point me to the explanation for a simple checksum algorithm I could write in PL/SQL. It doesn't have to be very fast, and it only has to detect typographical errors in 5,6 or 7 digit numbers. I looked at CRC, but I could not figure out what that was doing...

Hi I've written a TableModel to support my JTable. It takes a CachedRowSet in its constructor, since this is the data I am trying to show. The CachedRowSet does not seem to have a method to move the cursor to an arbitrary row, even though all the data is in memory, which is peculiar. So, in...

Hi I can't figure out owa pattern. I've read the docs and googled, but I can't figure it out. As part of my algorithm, I want to examine a string using regular expressions, and for each match, extract the match (ie extract the substring). I don't think either of the owa_pattern subprograms...

Hi I am not completely fluent in PL/SQL. But then, I'm not 100% sure how I'd do this in any other language anyway. I want to write a function which standardises a string which is sent to it. Basically, the string is a chemical molecular formula. So for example, C2H6BrC -> BrC3H6 because I...

Hello I have an stored procedure to write and I prefer Java personally, but thought that PL/SQL might be a better choice because of performance. I'm not an expert but doesn't it essentially run in the Oracle process as opposed to Java, which runs in it's own JVM? I was surprised when I did a...

Hi This is just a general question - I'm using .net, and in one of the applications I'm doing I'd like to 1. Inform the user of how long it will take to complete a given query. 2. Inform them of progress. 3. Allow them to cancel the query, and free the server from executing it. With the...

Is this possible? For example, if I pass SQL (A union B) minus (A intersection C), is there any way to make Oracle understand that it needs to keep the results of subquery A in memory and use it again? The explain plan shows that Oracle does not do this. And this document seems to suggest...

Hi What I'm trying to do is simple for jscript, but I need to use vbscript. In a web page, I've got essentially a control array which I generate from server side code. I can get the server side code to include the onclick="MySub" attribute for each element, and I know how to make the...

Hi - I posted this message first on GotDotNet, then MSDN, but no one has replied. Alas, the days when MS people were pushing .net so hard that they seemed to be on those sites permanently are gone. Maybe someone here knows the answer Subject - Data Grid Template Columns at Run Time Hi Suppose...

Hi We've got a couple of Access databases shared off a Windows 2000 server. Some of the users are using XP/Access 2002, but the rest are using NT4/Access 97 for the moment. I originally wrote the databases in 97. The problem is that I'd like the people on XP/2002 to be able to continue to use...

Hi I've got an Intranet web app which has a page where people can enter custom SQL and bring back the results. Obviously the user under which the SQL runs is highly restricted so that they can't drop tables etc. But they can still do crazy stuff like make a query which takes 57 years to run or...

Hi Three tables. Synthesis_Plates, with a one to many relationship to Synthesised_Compounds, which in turn has a one to many relationship to Anal_Plates_Compounds My query - for each synthesis_plate, pull back some information from the synthesis_plate table, along with the number of related...

Hi This seems to me such a common thing to want to do I've got a table with a numeric column. In this case, it is a purity value, which ranges from 0 to 100%, to two decimal places. There are a few hundred thousand rows. What I'd like to do is produce a histogram showing the frequency...

Hi I've got an load of sp's in an Oracle package, and I want to call them from my middle tier, which is using ole db (well, .net actually, but I don't think that matters) to talk to Oracle. I've been using this quite successfully for a while for both input and output params, of all data types...

Hi In ASP.net, we get a global exception handler in the global.asax which I use to e-mail me the details of unhandled exceptions, and to redirect the user to some sort of apology page, and this works fine. However, I'm writing my first Windows Service now and I'm puzzled. If I do this Throw...

Hi I have a query I would like to build where I want to find related information in a distantly related table. For example each Library has many Synthesis_Plates, which in turn have many Synthesis_Compounds, which in turn have many Analytical Submissions. My question is how to find the...

Just wanted to let you all know. It's fantastic - if I ever have to do another project in classic asp I may leave my job. Mark [openup]

Hi I'm trying to get some of the simple .net remoting examples on the net up and running, but I have two problems 1. Most of them are in C# 2. (More seriously) - most of them are console apps compiled from the command line - I can't get them running within VS.net - they all fail at the line...

Hi I am planning to write a stored procedure which takes in some parameters and inserts records on two tables. In the first table it just inserts one record, and since a trigger is defined on this table, this updates a sequence for the primary key. The proc then gets the currval of that...