Hey Tom, I have a Java application that runs thousands of different types of queries against an Oracle database millions of times. I wanted to save the query preparation time by using the oracle.jdbc.implicitStatementCacheSize JDBC property to cache prepared queries. But I easily...

I have an interesting request from our Warehouse Team. They require us to enable supplemental logging on ALL COLUMNS on core tables, we already have force logging for our DG. Our DB size 60TB. Interestingly our SLA's on processing is 3/4 seconds. Can I both Supp and Force looging...

declare     raw_hash  RAW(20); begin     /* 4000 + 1. */     select standard_hash(    [literal string of length 4000]                           || '-'                         )       into raw_hash       from dual     ; end;

Can you give me a solution for converting CLOBS datatype to VARCHAR datatypes, all the documents I refer to talk about converting BLOBS to VARCHAR and when I try and apply the examples to CLOBS, get errors

I have to open a url having image and display from oracle forms in a separate browser window. Since the image will change for every transaction, the image should show in same window. My forms is running on Oracle EBS R12.