Oracle 18c has been released.
How does it impact you as a developer or a DBA?
How can you get access to it to play around with some of the new features?
Keep reading to find the answers to this, and more.
The software development industry has a lot of conferences.
And Oracle is no different.
So, you’re interested in becoming a database developer?
I’ll show you the path you can take, what skills are needed, and much more, in this article.
Changing the case of text in Oracle is a common task when comparing strings or validating data. Learn how to do it with the UPPER, LOWER, and INITCAP functions in this article.
Do you need to use sine, cosine, or tangent functions in your queries or database code?
Oracle has plenty of those functions you can use.
Learn how to use them and see some examples in this article.
Do you need to find out more information about your errors and exceptions in PL/SQL?
You can use the SQLCODE and SQLERRM functions to do that. Learn how the functions work and see some examples in this article. read more…
Oracle’s two INTERVAL data types are used to store a period of time. There are a few functions that convert data into these data types. Learn how to use them and see some examples in this article.
In this article, I’ll explain what the TO_BINARY_DOUBLE and TO_BINARY_FLOAT functions do and show you some examples.
In this article, we’ll look at the different LOB functions available in Oracle, learn what they do, and see some examples.
There are several functions in Oracle, such as NVL and NVL2, that perform some kind of logic on the values that are provided. Learn what they all do and see some examples in this article.