Hello all, I am trying to create a sequence in oracle sql, using the "minvalue" as the result of a select query. The select query I'm trying to run is: SELECT MAX(customer_id) + 1 FROM customer I know it's easy with an anonymous pl/sql, but I'd like to find a way which doesn't use pl/sql. Some ideas I've had include the ...
Is there any way of constraining a column (say "ID") to follow a created sequence (say "ID_SEQ")? Without an automatic constraint, manual inserts might throw the entire sequence out-of-whack. What can be done to fix this? Just call NextVal twice? ...
Hi everyone , lately i've faced a problem which gets me so confused , the problem is : i want to compress a sequence so no information is lost , for example : a,a,a,b --> a,b a,b,a,a,c --> a,b,a,a,c (it can't be compressed to a,b,a,c because in this way we lose a,a) Is there any algorithm to do such a thing ? what is name of this pr...
Hi experts, I was wondering what the most computationally efficient Python way of cracking this problem would be. Say you have two strings (or lists from splitting those strings--doesn't matter), "this is the right string" vs. "this is right the string." We're assuming that the first string is always right, and a score will be assigne...
Let's say I have an sql server table: NumberTaken CompanyName 2 Fred 3 Fred 4 Fred 6 Fred 7 Fred 8 Fred 11 Fred I need an efficient way to pass in a parameter [StartingNumber] an...
I have three images and I would like them to First Image: fadeIn, wait a while, then fadeOut; Second Image: (on the same place) fadeIn, wait a while, then fadeOut; Third Image: (on the same place) fadeIn, wait a while, then fadeOut; //do something... I have this stupidity so far. $(document).ready(function() { $('#i...
Hello everyone. I'm in need of very specific class, I would really like to know if there is existing one, so I don't have to re-implement it. I have a set of items. Each item has a numeric value associated whit it - weight. Weight of each item is unique within set. Items must be sorted by weight. Weight can be modified for each item, but...
I need to add: an ID to the table in my form a numbered sequence of classes to a certain amount of TD's in every next TR in that table (three td's in this case) I've got next html-model: <form id="myform"> <table> <tr> <td>some text</td> <td>some text</td> <td>some text</td> </tr> <tr> <td>some text</td> <td>some text</t...
So, there's a project around these parts that's pretty old. It's using Java 1.4 and XFire to produce code-first web services (I know, I know, best practices...). Anyways, the heads have recently decided everyone needs Websphere 7 now! Upgrading to Websphere 7 changed the WSDL significantly. For example, before, if this was the order ...
Given a collection I want to iterate through all paris in a collection. Example (all-pairs seq) (all-pairs '(a b c d)) => ([a b] [a c] [a d] [b c] [b d] [c d])) Here is my idea (defn all-pairs [coll] (for [ [idx elmt] (indexed coll) other-elmt (subvec coll (inc idx))] (vector elmt other-elm))) But it doesn't feel i...