FB
Oracle Mathematical Functions

Oracle Mathematical Functions

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
Oracle SQLCODE and SQLERRM Function Guide, FAQ, & Examples

Oracle SQLCODE and SQLERRM Function Guide, FAQ, & Examples

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 Interval Functions Guide, FAQ & Examples

Oracle Interval Functions Guide, FAQ & Examples

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
Oracle TO_BINARY_DOUBLE and TO_BINARY_FLOAT Functions

Oracle TO_BINARY_DOUBLE and TO_BINARY_FLOAT Functions

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