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 Mike Lewis 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: mratx
  • Order by date
  1. mratx

    Normalize Column Data

    Wow! Blazing fast! This is night and day compared the what I had, and I would give you 5 stars if I could! Thanks so much for your help!
  2. mratx

    Normalize Column Data

    Thanks for the reply. This is essentially what my regexp does, except you added a DISTINCT to get rid of the duplicates. I appreciate seeing another way to do this, but performance wise, it's just as bad as the regexp version. I guess what I need is a query that won't create duplicates to begin...
  3. mratx

    Normalize Column Data

    I have an old ugly system table that I need to normalize. It contains a pipe delimited part numbers list in one field and a corresponding node in another column. Here is an example: CREATE TABLE lookup( part_number VARCHAR2(100), node NUMBER ); INSERT INTO lookup(part_number...
  4. mratx

    String Permutations

    I'm trying to write a string permutation function, and I want to include all combinations of the letters ranging from 1 to n in size. I got this to work, but it includes duplicates: function permutate(permutation, addendum) { if (addendum.length == 0) { console.log(permutation); return; }...

Part and Inventory Search

Back
Top