Here is the solution for most common causes of Oracle SQL ORA-00942: table or view does not exist exception. 1. Problem Below is the most common example when you got…
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…
This is a solution for an exception occurred when you try to run Node.js application required oracledb module. (more…)
This is a solution for an exception occurred when you try to run Node.js application required Oracle Database.
Workaround for some exceptions during JDeveloper launch process and designer initialization.
![[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…
Library dependency management is one of the most missing tools in Oracle JDeveloper 11g. It is true that Maven support has been added in JDeveloper 12c. Nevertheless, in the older projects you may want to use Gralde integration described in this article. This approach also works with JDeveloper 12c.
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.
SonarQube is an open-source platform for continuous inspection of code quality. It’s one of ‘must have’ tools in every software development company. This tutorial helps you to integrate any Java based application (in this case Oracle ADF) with Sonar using one of Gradle plugins.