Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Custom24
  • Content: Threads
  • Order by date
  1. Custom24

    Compression of contents of a Long field

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

    Simple Checksum

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

    JTable TableModel getValueAt when using CachedRowSet

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

    owa_pattern help

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

    Collection or In-memory table for algorithm?

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

    Speed of Java versus PL/SQL

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

    Advanced Query Functionality

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

    Subquery Refactoring Oracle 8.1.7

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

    Simple Event Handler Question Control Array

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

    Anyone care to beat MSDN and GotDotNet?

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

    Access 2002 opening an Access 97 mdb

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

    Refusing to run a query which will take too long?

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

    Improving performance of query by inlining function into SQL

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

    Producing a frequency distribution from Oracle 8i numeric data

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

    Problem calling Oracle stored procedure from ole db

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

    Windows Service Unhandled Exceptions

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

    Joining lots of tables in a many to many - firstrows enough!

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

    I love ASP.NET

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

    .net Remoting - any good VB resources?

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

    PL/SQL proc - sequences - how to get currval

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

Part and Inventory Search

Back
Top