Category: Database
OWASP Juice Shop
In this article I would like to briefly introduce the OWASP Juice Shop - a great way for both inexperienced and experienced developers to learn about common security vulnerabilities in applications.
Markdown column for non-standard templates for classic report
Recently I have developed an internal application for knowledge sharing using Oracle APEX. In this application, I have used many interesting new features from 19.2 and 20.1.
Multi-client capability with PostgreSQL
In an application with several clients, it must be ensured that the data of one client is not displayed for others or can be changed by the actions of others. This article describes a solution for PostgreSQL databases.
How to import an Oracle APEX Application export file from a higher version into a lower version
Recently we developed Oracle APEX application in our APEX 18.1 environment. Trying to share the tool with one of our customers, we realised that they are still using 5.1.4 and won’t be able to update within short time.
Multilanguage database applications using Oracle APEX
Hello Everyone! If you are a DBA/PLSQL guru but are not familiar with traditional web development, then Oracle APEX is one of the best option. In this context, if you are trying to build a multilanguage application with Oracle APEX then this article should give an overview and understanding of how the translation mechanism that is built-in to Oracle APEX works, and how you should handle it. It is based on Oracle Application Express 18.1 version.
Naming conventions in Oracle databases
Naming conventions are an important part of coding conventions. Naming conventions are the rules for how “things” are named. In the case of a database, the “things” being named are schema objects such as tables, sequences, indexes, views, triggers as well as constraints. In a database it is essential to choose names with particular care.