Oracle 12c(12.1.0.2) Has Arrived….

Just checked Tim’s latest post and guess what, Oracle database 12c’s latest release, 12.1.0.2 is available now for download. It is available as an OTN download as well as from E-Delivery. Seems like that there is no documentation update available yet as the New Features guide still doesn’t have 12.1.0.2 included in it. But I am sure that it’s coming soon!

So grab your copy now and happy downloads :=).

Packt Shares Its Full Range of eBook/Video For Just $10….

Yes, that’s correct! Packt Publications is celebrating 10 years of effective learning and information services to IT professionals. To make us part of this celebration, the good guys  are offering all eBooks and Videos at just $10 each until July 5th. So this would be a really good chance to get any e-book or Video of your choice in such a good price. Sounds good? Well follow this link then,http://goo.gl/Dnn5RP.

And since every (more...)

Fun : Impressionnant !





Fun : Suivez moi !

Suivez moi sur http://www.flightradar24.com  (Vol Air France AF84)

Fun : Lunettes Tag Heuer Oracle Team USA

"The TAG Heuer RACER "ORACLE TEAM USA 34th America's Cup winner" Limited Edition combine two different types of high-tech materials: the Grilamid TR90, a nylon well known for its resistancy, lightness and shape memory, and the carbon fiber coming from a piece of ORACLE TEAM USA AC72 boat."

FritzBox 7270: CLIP stops working after upgrading to FritzOS 6.05 (problem solved)

After upgrading to FritzOS 6.05 CLIP stopped working with my analog phone.
The settings looked quite ok: (Telefonie -> Telefoniegeräte -> bearbeiten -> Merkmale des Telefoniegeräts)

This basic feature was certainly not shipped without testing. So this has to be a problem of data/parameter migration.
After unchecking CLIP, doing a reboot and ba checking the box again CLIP worked like before...

Dynamic Registration In 12c Using LREG….

There is a lot of change that release 12.1 or 12c has brought up. And it’s not in the more advanced new features that I am talking about but even in some areas about which, we have memorized a particular concept by heart from last many years. Once such change is what I am going to mention in this post-introduction of the LREG(Listener Registration) process.

Basics of Dynamic Registration
In the earlier releases,to register (more...)

WordPress 3.8.2

Just the usual upgrade of WordPress to the latest version 3.8.2. If you are able to read this, it went fine :=).Download it from here if you haven’t done it already.

Packt’s 2000th Title Campaign….

I received an email from Packt Publication that they are celebrating the release of their 2000th publication. And to include everyone in this celebration, Packt Publication would be giving an awesome offer to the readers to buy one (any from their catalogue) and get along with it one book, FREE!!!! Now, how cool is that, isn’t it? So if you are willing to buy a book from Packt Publication, no time can be better than (more...)

Best Practice in 12c

Since PL/SQL now is closely integrated into SQL, we hence can happily state
sokrates@12.1 > with function bestpractice return varchar2
  2  is
  3  begin
  4     return 'Do not use PL/SQL when it can be done with SQL alone !';
  5  end bestpractice;
  6   (more...)

A bit of fun expressing ratios

Sometimes answering questions on the OTN forum leads to a little fun trying to be creative in SQL ;-) A user wished to express a ratio as 1:1 or 1:2. That lead to a little fun with CONNECT BY on DUAL for recursion.


This is the SQL I ended up creating:

with r as (
select .2233 ratio from dual union all
select .2500 ratio from dual union all
select .2666 ratio from dual union all
select .2750 ratio from dual union all
select .2828 ratio from dual
)
select r.ratio ratio_num
, (
select to_char(
max(level)
, 'TM9'
(more...)

Find your way with HttpUriType and Google Maps

Recently I read Duke Ganote writing about using UTL_HTTP to get stock quote from Yahoo. (Duke must have a thing for authorities, particularly Marshalls of Legoredo ;-) Anyway, I posted a comment how to do a similar thing with HttpUriType.

And that reminded me that long time ago I reminded myself that I should blog about how we use HttpUriType to query driving distance and time from Google Maps. (I have even tried to submit abstract to KScope and UKOUG on getting data with HttpUriType, UTL_HTTP or UTL_FTP, but no go so far...)


Let's imagine Larry needs directions to (more...)