Blogs

Help Santa with SQL and get gifts from Devart!

articles: 

We are happy to bring our sincere congratulations with upcoming Christmas and New Year holidays! It’s time for miracles and gifts, so try yourself at Devart’s Christmas Quest to get winter holiday discounts.

Help Santa to count a salary for his Elves so that they deliver other presents. With this purpose, Santa uses SQL query, but he is not so good in SQL. Please, help him to build the proper query! Santa Claus is about to pay generously to everyone who helps him!

weblogic administration online training

articles: 

Weblogic Administration Online Training

This course introduces the student to Oracle WebLogic 12c. Students will learn skills necessary to understand basic WebLogic concepts and
administrative tasks. At the end of this course the student will learn how to install WebLogic, create WebLogic domains, and administer WebLogic.

12.2 upgrade - it can break all your outgoing https calls

Do you know about multiple domain certificates? If not you may have to learn quickly, because Oracle has changed the way they are handled in release 12.2. This is going to break a lot of applications.

Configuring Oracle Financial Accounting Hub

articles: 

Configuring Oracle Financial Accounting Hub

Sending Email from PLSQL from Gmail

articles: 

How to send Email in Oracle using Gmail.
Email sending by using Oracle through Gmail:

BEGIN EMAIL_GMAIL.SEND ('shabbier.sa@gmail.com','shabbier.sa@gmail.com','Your email subject','Emaisaaasdasal Message body'); END;

Upgrading to 12.2 ? Make sure you won't break JSON

articles: 

Will upgrade from 12.1 to 12.2 break your applications? It may if your developers are using JSON.

Tuning with equivalent SQLs - a little challenge

articles: 

I am fascinated by what I call "equal SQL": statements that are equivalent, in that they deliver the same result but may have hugely different performance characteristics. Here's a little case study.

Compression test, 12cR2

articles: 

Just how effective is Hybrid Columnar Compression? This test shows that HCC is impressive, but that thought needs to be put into choice of compression algorithm.

Pages

Subscribe to RSS - blogs