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 derfloh 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: userMikeD
  • Content: Threads
  • Order by date
  1. userMikeD

    Faster XML Append Method?

    Hi, I need to append some XML to a vary large XML doc (6.7mb), and it's taking a really long time. For one or two records, it wouldn't be a problem, but I have to do this on hundreds of thousands of records. Here are the three different ways I've tried so far: dbms_xmldom: FUNCTION...
  2. userMikeD

    Query Refactor for Better Efficiency

    Hi, I'm writing a query which will grab translations from a table. The rules are that I select the keys with the specific locale first, then I select the keys with the language, finally select the rest in english. I wrote the query below, but I'm not happy with the 12 step explain plan and cost...
  3. userMikeD

    print hex value of a random number

    I can print the hex value of a given number using printf printf "%02x\n" 2 -> 02 printf "%02x\n" 20 -> 14 printf "%02x\n" 200 -> c8 I need to print the hex value of a random number, 0-127, but can't seem to get that working. I tried this: printf "%02x\n" ${RANDOM}%128 What do I need to do...
  4. userMikeD

    Detect calling database

    Is it possible to detect the calling database that accessed a function over a dblink? I have package on a remote database that needs to detect who called it. For clarity, consider a remote DB we'll call RDB that has package x and a function main. On a staging DB, I make this call: v_return :=...
  5. userMikeD

    Firefox not blocking script like IE and Chrome

    I need to include an external javascript file, but if it takes over 2 seconds, I want to remove it and block it from running. The following code successfully removes and block the external script from running in IE and Chrome, but not Firefox. Note: jQuery dependency var gTimeout, gScript...
  6. userMikeD

    Reformat XML

    Hi, I'm having trouble with a simple transformation. Here is my XML: <?xml version="1.0" encoding="UTF-8"?> <translationSet> <key name="SMCAM1744_TITLE" translator="" translationDate=""> <comment/> <contextImagePath/> <text>Camera 1744</text> </key> <key name="SMCAM1762_TITLE"...
  7. userMikeD

    Escape Latin Characters

    I need to escape latin characters in an xml doc. Example: "é" is escaped to "&#233;". I thought I could use the ASCII function, but SELECT ASCII('é') FROM DUAL in Oracle gives me 50089. I coded this as a quick fix, but I'm sure there's a better way. FUNCTION escape_latin(p_str IN...
  8. userMikeD

    Oracle encryption -&gt; Java decryption

    Hi, I'm writing a java app that needs to retrieve encrypted values in a table, and decrypt them on the java side. The oracle side encryption and decryption works fine, but I'm getting null on the java side. Here's Oracle code that works to decrypt the value: SELECT CONVERT(key_1...
  9. userMikeD

    De-dupe

    I'm trying to de-dupe and concatenate some values from a table to form a new "consolidated" view. my data looks like this: USER_ID APP CREATION_DATE APP_DATA 1 PF <timestamp> abc 1 PF <timestamp> abc 1 PF <timestamp> def 1 PF <timestamp> xyz 2 PF...
  10. userMikeD

    When to use dbms_xmlparser

    Hi, I'm trying to figure out when it's a good idea to use or not use dbms_xmlparser. It seems like I can create a domDocument without needing a parser, but most examples I see online use a parse. Something like this: OPEN emp_refcur FOR SELECT * FROM employees; xml_ctx :=...
  11. userMikeD

    Use a boolean return in a where clause

    Hi, I have a package that has a function and it's return type is BOOLEAN. In pl/sql, I'm able to say: IF (pricing.does_qualify(p_profile_id)) THEN .... END IF; However, I can't seem to get it working in a select statement. For instance, I've tried to evaluate the function the following ways...

Part and Inventory Search

Back
Top