Oracle
in [SQL]
|
Our customer websites are modern, fresh and accessible. The Frontier Group is a passionate web design and web development company based in Perth, Western Australia. We design and deliver beautiful, functional and accessible web sites & web applications. http://thefrontiergroup.com.au/ ... 29 May 2010 19:01
Our customer websites are modern, fresh and accessible. The Frontier Group is a passionate web design and web development company based in Perth, Western Australia. We design and deliver beautiful, functional and accessible web sites & web applications. http://thefrontiergroup.com.au/ ... 30 May 2010 10:00
Bitmap index partitions and recursive calls Hi, Oracle 10.2.0.4 What is the relation between partitioned bitmap indexes and number of recursive calls shown by Autotrace? I have seen that as the number of partitions on a table increase, for a query using bitmap indexes, the number of recursive calls also increase. When the number of partitions on the ta... 2 Jun 2010 08:42
Understanding this query Hi, Ok, we have a VERY complex query here which is dynamically made. The issue we are having is this: Take a look at the inner part of the query, there is a dynamic column with some XMLAGG functions called "tag_list". If I do not place that column in the outer most part of the query, it runs in like .1. H... 28 May 2010 06:03
Oracle 11 Server and Unicode UTF-8 Hi, We're running Oracle 10g on Windows using ISO 8859 as the character set. We're exploring the idea of converting to unicode (UTF8) along with the upcoming upgrade to v11. I haven't found a good reference for how to best accomplish the conversion and what pitfalls to watch out for. Any suggestions? On... 3 Jun 2010 15:37
Top 10 Technical requirements for In-Memory Reporting Top 10 Technical requirements for In-Memory Reporting With Gartner's Business Intelligence group listing In-Memory analytics at the top of their recommended Business Intelligence requirements for enterprise; No wonder In-memory has become a trending topic in BI and a new addition to executive shopping lists. ... 27 May 2010 09:14
Off Topic: open source databases I guess this is a legitimate topic now that MySQL is essentially an Oracle product, too. My question, however, is not devoted to MySQL or any other specific OSS database. I am just interested in what OSS databases are mostly used in data centers, in addition to Oracle and why? Specifically about MySQL, did the f... 30 May 2010 07:52
CLOB Ok, I've seen all the notes on the ORA-22992 error: ORA-22992: cannot use LOB locators selected from remote tables Problem is that we are using a source table with a trigger that will update another table on a remote database over a DB link. So, if you cannot update, how is this task to be accomplished? I... 27 May 2010 09:14
Ramming two SQL queries together..... Hi Everyone, I am wanting to ask some advice before attmepting this as I am afraid I might tie up too much resource on our DWH - and that would tick off the admins (understandably). I have two SQL statements that provide me with data, both very similar and based off the same tables (one uses only a subset of t... 31 May 2010 16:22
Rman backup of BCV using ASM Hi All, could you please have a look to my query. ... 25 May 2010 16:50 |