In the last post, I did talk about what’s Machine Learning(ML) in general. In this post, we shall understand what’s Oracle Machine Learning(OML). To give a recap, ML is basically telling an algorithm to find what a human can’t find by his own. Reasons for humans not able to find the infers between different data … [Read more…]
I have started to work on Machine Learning(ML) from some time or more precisely on Oracle Machine Learning. It’s a long way to go and I shall be adding here my learnings. This post is kind of an introductory post for all who are not aware about ML, what it does and how it’s … [Read more…]
With the advancement of the databases, requirement to access the data as fast as possible is increasing day by day. Not only this but the data is not restricted anymore from the standard business applications only and can be generated from a wide variety of sources. For example, now everyone has a phone and that … [Read more…]
In 12cR2, there is a new function introduced to determine that whether a given input can be converted to a given data type or not. Using this function , it’s easy to determine that whether the column values can be converted or not. If the conversion is possible, the function returs 1 else it returns … [Read more…]
I am working on refreshing my set up with the latest version of database – Oracle 19c. In order to do so, I have made a new VBox vm with OEL 7.6 as the base operating system. One thing that I didn’t find in the installation(or may be I missed it completely) was to set … [Read more…]
Oracle database 18c has come up with some really useful features and the new features guide is the best place to get started-as always. In this post, which is the 1st post about 18c, I shall mention two very simple yet very helpful features introduced for SQL statements. So without further adiue, let’s get to … [Read more…]
Test Post. Will be deleted soon.
I am speaking at Mumbai leg of OTNYatra 2007. I shall be presenting about high availability in RAC and what are different options and configurations possible in it, including the 12c specific Transacion Guard and Application Continuity. If you are attending, do come at my session at 4pm and say Hello!
One of the biggest things that we couldn’t do in the previous versions of the oracle database was to use the back arrow button-to reexecute the old commands, without typing them. Of course, a workarouns is possible in the form of rlwrap but it’s not comparable to a natively available feature in the SQL*PLUS. Well, … [Read more…]
There are many features in the database and all of them are super useful. But on this day, I chose to go with the latest and probably the greatest feature introduced in the oracle database 220.127.116.11-In Memory Column Store. From a long time, there has been discussions about how a database should be using column … [Read more…]