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. Purpose of the UPPER, LOWER, and INITCAP Functions The Oracle UPPER function takes a string... Read more

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. What Are The Mathematical Functions? The mathematical functions are... Read more

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. Purpose of the SQLCODE and SQLERRM Functions The SQLCODE... 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. What Are the Oracle INTERVAL Functions? There are four INTERVAL... Read more

In this article, I’ll explain what the TO_BINARY_DOUBLE and TO_BINARY_FLOAT functions do and show you some examples. Purpose of the Oracle TO_BINARY_DOUBLE Function The TO_BINARY_DOUBLE function converts an expression into a BINARY_DOUBLE data type. This is a... Read more