FB
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
Oracle LOB Functions FAQ, Guide, and Examples

Oracle LOB Functions FAQ, Guide, and Examples

In this article, we’ll look at the different LOB functions available in Oracle, learn what they do, and see some examples. Purpose of the Oracle LOB Functions There are a few LOB-related functions in Oracle. What are they all for? TO_CLOB The TO_CLOB function converts... Read more