File Library

Yalim Kerem Gerger, Gerger

Version management of the PL/SQL source code has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file-based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid writing code in PL/SQL.

In this presentation, you will learn how you can use Git, the prominent open-source version-control software built for distributed teams, to manage your PL/SQL source code. Using these techniques, you can manage your PL/SQL source code just like any other development team manages their file-based code base written in languages such as Java, JavaScript, or C#.

In this presentation, you’ll also learn:

*How Git can empower you to implement any development workflow within your team and make this workflow an inseparable part of your development process.
*To automate most time-consuming tasks, such as merging changes in multiple packages, procedures, and functions.
*To execute commonly used version-control commands in the Oracle Database, such as reverting to a previous version of your source code, creating a new branch, and changing between branches, and how executing these commands can change the source code in the Oracle Database automatically.
*How to get the differential script between two Oracle Database source-code repositories automatically.
*How to minimize any errors, such as overwriting over newer version of packages, procedures, and function.
*How to prevent anyone from editing source code in the database outside of a version-control system.
*How you can have multiple teams change the same logical packages, procedures, and functions and merge their changes automatically.
*To create a reliable audit trail and change log that documents every change to your code base.