Generating and Validating XML from Oracle DB.
XML (eXtensible Markup Language) is a powerful way to represent structured data in a human-readable format, and Oracle Database offers a variety of tools for creating, manipulating, and validating XML…
PL/SQL
Connecting SQL Developer to the DB server using a SOCKSv5 SSH proxy
Using a proxy server or bastion host when connecting to an on-premise database provides several key benefits in terms of security, access control, and network management. A proxy server acts…
Summary of DBMS_SCHEDULER in Oracle
DBMS_SCHEDULER is an advanced job scheduling and management package in Oracle that offers extensive features and flexibility. It is designed to schedule and manage a wide range of tasks, from…
OAuth2.0 client authentication from PL/SQL
OAuth 2.0 is an open standard for authorization used for granting applications limited access to user resources without exposing their credentials. Nowadays, it is broadly used for securely accessing web…
Mastering Oracle: A Practical Guide to the Segment Advisor
The Segment Advisor in Oracle 19c is a powerful feature designed to identify inefficient segments within your database and recommend appropriate actions to optimize space usage. It works by analyzing…
Shrinking fragmented free space on Oracle tables
Oracle tables can become fragmented due to excessive Data Manipulation Language (DML) operations such as insert, update, and delete. When rows are inserted into a table, the High Water Mark…
Getting objects definition in PL/SQL.
SQL Developer is a powerful and user-friendly tool that greatly simplifies the work of database administrators. It provides a graphical interface for database management and development, making it easier to…
Writing to the alert log from PL/SQL with DBMS_SYSTEM.ksdwrt
Writing to the alert log from PL/SQL in Oracle Databases can be a convenient way to monitor significant events or errors that occur during database operations. For example, you could…