Search results for query: *

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

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

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

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

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

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

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

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

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

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

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