[SOLVED] ORA-00942: table or view does not exist. Hints to solve the problem
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…
[SOLVED] PLS-00201 – identifier must be declared. Hints to solve the problem
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…
[SOLVED] NJS-045 ORA-01804: Error while trying to retrieve text for error ORA-01804
This is a solution for an exception occurred when you try to run Node.js application required oracledb module. (more…)
[SOLVED] NJS-045 DPI-1047: 64-bit Oracle Client library cannot be loaded
This is a solution for an exception occurred when you try to run Node.js application required Oracle Database.
[SOLVED] JDeveloper 12.2.1.2.0 – long designer initialization/exceptions
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)
[PL/SQL] How to convert date to Unix Timestamp
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)
[PL/SQL] How to generate UUID
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…
Oracle ADF and Gradle integration – part#3: Dependency Management
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.
Oracle MOOC: Introduction to PL/SQL Program Units 2018
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.
Oracle ADF and Gradle integration – part#2: SonarQube
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.