Here is the solution for most common causes of Oracle PL/SQL PLS-00201 - identifier must be declared exception. 1. Problem You got a PLS-00201 - identifier must be declared exception…
![[PL/SQL] How to convert date to Unix Timestamp](https://better-coding.com/wp-content/uploads/2018/05/unix-timestamp-fature-fs8-300x113.png)
Unix Timestamp describes the point in time as the number of seconds that have elapsed since 00:00:00 (UTC), Thursday, 1 January 1970. The simple function implemented in this post helps…
![[PL/SQL] How to generate UUID](https://better-coding.com/wp-content/uploads/2018/05/plsql-uuid-feature-fs8-300x113.png)
The UUID (Universally Unique Identifier) is a 128-bit number represented as five sequences of hex digits separated by dashes. It may be used to identify some information like message, record…
Another Oracle MOOC has just started. This time you have an opportunity to learn about PL/SQL Program Units starting from anonymous block, through stored procedures, to more advanced topics. In this post I will show you how to prepare your own development environment for the MOOC purposes much faster than it was described on the official course site.
This is a solution for an exception occurred during enqueuing/dequeuing or managing Oracle AQ in PL/SQL
The PL/SQL Fundamentals 2018 is a yet another free course prepared by Oracle. The course began on January 15th and it’s open for 21 days. This course is really worth it to take time for it. Good lock!