In this article, I’ll explain how to use the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH functions with some examples. I’ve grouped all of these functions into a single article because they are quite similar and are related functions. Purpose of the Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions The purpose of these functions […]
As part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article. What Did I Need To Do? For the web app, I needed to output a table of data. This table needed to display row […]
In this article, I explain what the GROUP_ID function does and show you some examples. Purpose of the Oracle GROUP_ID Function The GROUP_ID function is used to assign a number to each group that results from a SELECT query clause with a GROUP BY clause. It’s used to identify any duplicate groups in your output, […]
In this article, I explain what the different data types are in Oracle database and everything you need to know about them. What You’ll Learn about Oracle SQL Data Types There are many data types in the Oracle database. There are character, number, date, and other data types. When you create a table, you need to […]
With the current release 12.2, flashback can be done on the PDB layer. As a prerequisite, the database must be put into local undo mode. That means that each PDB has its own undo tablespace. Some other 12.2 features like hot PDB cloning also require this, so chances are that most 12cR2 multitenant database will be using that mode.
Tomorrow I head off to Bulgaria for the BGOUG Autumn Conference 2016. I’ve only been to the Bulgarian user group once before, having heard from so many people what a fantastic user group conference it was – and they were right. Milena Gerova and her team do an amazing job of organising it and make everyone feel really welcome. So I am really looking forward to my return.
I hadn’t been to Raleigh in years. It was probably 5 or 6 years ago that I was there last. Raleigh, NC of course is part of the Research Triangle. There are a lot of tech companies in the area and North Carolina is a great mid Atlantic location for a conference. Because Raleigh is easy to get to the East Coast Oracle Users Conference tends to be one of the ‘larger’ regional conferences.