google7ee7f750db33e29f.html

By -
google-site-verification: google7ee7f750db33e29f.html
Location: San Francisco, CA, USA

Popular posts from this blog

Android App for Data Warehousing and Big Data at #oow15

By -
Image
A number of people have asked if I could make a smartphone app version of my usual OpenWorld web app ( OpenWorld 2015 on your smartphone and tablet ) which does not require a data or wifi connection. For Android users there is some good news: here is my new Android app for OpenWorld that installs on your smartphone and runs without needing a wifi connection or a mobile data connection. This  DW and Big Data app  is nice and small so it is quick to download and install onto your phone. It contains everything you need to know about data warehousing and big activities at OpenWorld. The app has sections for: Key Oracle Speakers - arranged by category  Data warehouse and big data sessions by Oracle product managers, key partners and customers. Organized by category and day-by-day Hands on Labs. Organized by category and day-by-day Maps to help you find your way around Moscone and the surrounding area To download the Android app click here:  DWBDoow15...
Keep reading

Managing overflows in LISTAGG

By -
Image
This is an interesting problem that has come up a few times in discussions (and I think it has been mentioned on the SQL forums as well).  When using LISTAGG  on very large data sets you can sometimes create a list that is too long and consequently get an ORA-01489: result of string concatenation is too long   error . Obviously, it is possible to determine in advance if the error is going to occur using some bespoke PL/SQL code and then take appropriate action within your application to manage the rows that contain stings that exceed the VARCHAR2 limit. Many customers have implemented workarounds to overcome the  ORA-01489  error, however, this has mostly involved the use of complex code which has impacted performance. Wouldn’t it be great if there was a simple yet elegant way to resolve this issue? Actually there is and we can use a few of the most recent analytical SQL functions. If you are using Database 12c you can make use of the  MATCH_RECOGNIZE  function to effecti...
Keep reading

Ultimate, comprehensive review for big data warehousing for #OOW18.

By -
Image
Here it is….. THE ultimate, comprehensive review for big data warehousing for #OOW18. This review is for everyone who either missed this year’s conference or just wants to relive the amazing experience all over again ( but focusing on just the best bits obviously! ). So here you go, my complete view nicely packaged and available free of charge in a number of different formats…           Following on from this year’s OpenWorld I have now put together the ultimate, comprehensive review for big data warehousing content from #OOW18. This free review contains the following information: Key video highlights from the main executive keynotes Overview of the announcements for Autonomous Database - contains the links you need to learn even more about how the Autonomous Database can simplify and speed up your big data warehousing projects! Full list of Oracle Product Management and Development presenters, links to all their social media sites are included alon...
Keep reading