File Library

Version Control for PL/SQL
Topic: Webinars
Owner: Yalim Kerem Gerger
Date: 2017-02-22

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.

Download File   02212017 Yalim Kerem Gerger.mp4
Download File   Version Control for PL_SQL ODTUG.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database