Here are some Open Source projects that may be useful. This is definitely not a comprehensive listing, it has been compiled from a survey of GitHub for open source projects that have something to do with Oracle SQL and Pl/sql. I have used the Project – About information for the title and a link to the project website.
I have included these projects because they are publicly available open source. Please feel free to contact me if you don’t want your project listed.
I have included projects on topics that I found interesting, or source code that may be helpful in some way. Reviewing code that has been created by others is one of the best ways to improve and establish our own skill and personal style as developers.
If you would like to have your project listed, just contact me and I will add it to the listing (ordered by the project sourcecode repository url). Please provide a link to the project source repository, the project title and the project website if there is one.
Source code for “Expert Oracle Database Architecture” by Thomas Kyte
https://github.com/Apress/exp-oracle-db-architecture
Source code for “Expert Oracle Database Architecture” by Thomas Kyte and Darl Kuhn
https://github.com/Apress/exp-oracle-db-architecture-14
Source code for “Modern Oracle Database Programming: Level Up Your Skill Set to Oracle’s Latest and Most Powerful Features in SQL, PL/SQL, and JSON” by Alex Nuijten and Patrick Barel
https://github.com/Apress/modern-oracle-database-programming
Source code for “Practical Oracle SQL” by Kim Berg Hansen
https://github.com/Apress/practical-oracle-sql
Oracle PL/SQL API Demos: Demonstrating Oracle PL/SQL API procedures for getting and setting database data, with code timing, message logging and unit testing
https://github.com/BrenPatF/oracle_plsql_api_demos
Oracle PL/SQL General Utilities Module
https://github.com/BrenPatF/oracle_plsql_utils
Example of a basic blockchain within the Oracle Database
https://github.com/Dani3lSun/oracle-blockchain
OakAcademy: Oracle Basic SQL
https://github.com/OakAcademy/Oracle.git
Logger is used by Oracle developers to instrument their PL/SQL code
https://github.com/OraOpenSource/Logger
Common PL/SQL utility scripts
https://github.com/OraOpenSource/oos-utils
Expert SQL & PL/SQL Book : Advice from the Experts (Oracle Press) Sample Code
https://github.com/Oralytics/SQL-and-PLSQL-from-the-Experts-Sample-code
Rene Nyffenegger: oracle-patterns
https://github.com/ReneNyffenegger/oracle-patterns
Rene Nyffenegger: Creating Excel workbooks (xlsx) with PL/SQL
https://github.com/ReneNyffenegger/xlsx_writer-Oracle
Trivadis PL/SQL & SQL Coding Guidelines
https://github.com/Trivadis/plsql-and-sql-coding-guidelines
PL/SQL Logger: Simple and effective logger framework for Oracle Database
https://github.com/ValeriyTyutyunnik/plsql-logger
The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL”
https://github.com/blackdogcode/OraclePLSQL
SQL scripts for Oracle Database Tuning
https://github.com/bobbydurrett/OracleDatabaseTuningSQL
Oracle PLSQL: Scripts PLSQL DW
https://github.com/eniltonsp/Oracle-PLSQL
Tales From A Lazy Fat DBA: My Oracle DB Scripts
https://github.com/fatdba/Oracle-Database-Scripts
Tools and Examples For PL/SQL API Development and Administration.
https://github.com/gaiansentience/oracle-architect-tools
Oracle PL/SQL API: Event Management Demo
https://github.com/gaiansentience/oracle-events-system-demo
Source Code For PracticalPlsql.org Articles By Anthony Harper
https://github.com/gaiansentience/practicalplsql
Liquibase extension to add improved Oracle support
https://github.com/liquibase/liquibase-oracle
ORACLE PLSQL LOGGER: A super simple logger used in PLSQL procedure, package and functions.
https://github.com/matitaweb/oracle-plsql-logger
ExcelGen – An Oracle PL/SQL Generator for MS Excel Files
https://github.com/mbleron/ExcelGen
PLSQL_LEXER 2.2.0: A PL/SQL package to solve real-world language problems
https://github.com/method5/plsql_lexer
Oracle PL/SQL Utility Library
https://github.com/mortenbra/alexandria-plsql-utils
Code generator for Oracle PL/SQL based on a simple markup language
https://github.com/mortenbra/quick-plsql
Oracle LiveLabs: A Collection of Open Source Repositories From Oracle
https://github.com/oracle-livelabs
Oracle LiveLabs: Analytics-AI
https://github.com/oracle-livelabs/analytics-ai
Oracle Livelabs: Database
https://github.com/oracle-livelabs/database
Oracle LiveLabs: University
https://github.com/oracle-livelabs/university
Oracle Database Sample Schemas
https://github.com/oracle-samples/db-sample-schemas
Oracle Database Sample Schemas 23c
https://github.com/oracle-samples/db-sample-schemas/releases
oracle-db-examples
https://github.com/oracle-samples/oracle-db-examples
Oracle APEX on GitHub
https://github.com/oracle/apex.git
Oracle Database Tools
https://github.com/oracle/oracle-db-tools
oracle-base.com scripts by Tim Hall
https://github.com/oraclebase/dba
PL/JSON
https://github.com/pljson/pljson
Oracle PL/SQL utility code
https://github.com/scott-swank/plsql-util
PL/SQL package written by Anton Scheffer which allows us to export Excel XLSX files from an Oracle Database.
https://github.com/sokolsaiti/as_xlsx
utPLSQL: Testing Framework for PL/SQL
https://github.com/utPLSQL/utPLSQL
wtPLSQL – Whitebox Testing for PL/SQL
https://github.com/wtPLSQL/wtPLSQL
Oracle PL/SQL Package for Microsoft Word Documents Generation
https://github.com/zorantica/plsql-word