Tags¶
Following is a list of relevant tags:
CI/CD¶
Merge¶
Oracle¶
- How I got into utPLSQL v3 development
- How I started to create Unit Tests for Oracle PL/SQL code
- Oracle MERGE operation - get number of rows inserted / updated deleted
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
PL/SQL¶
- Beware of raise_application_error from within exception when others
- How I started to create Unit Tests for Oracle PL/SQL code
- PL/SQL and SQL naming conventions
- PL/SQL performance freak series - function calls from SQL overhead
- PL/SQL performance freak series - function/procedure parameters overhead
- PL/SQL performance freak series – alternatives to PL/SQL function calls from SQL
- Test Drive your Oracle database. Yes, it's doable. And it's fun!
- Test Driven Development in PLSQL with utPLSQL v3 - intro
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
- utPLSQL v2 vs. ruby-plsql - exception handling
- utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison
Performance¶
- PL/SQL performance freak series - function calls from SQL overhead
- PL/SQL performance freak series - function/procedure parameters overhead
- PL/SQL performance freak series – alternatives to PL/SQL function calls from SQL
Ruby¶
SQL¶
- BUG in INSERT ... SELECT with nested objects
- INSERT ... LOG ERRORS and SQL%ROWCOUNT
- INSERT ... LOG ERRORS and SQL%ROWCOUNT-continued
- Oracle MERGE operation - get number of rows inserted / updated deleted
- SQL*Plus default values for script parameters
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
TDD¶
- How I started to create Unit Tests for Oracle PL/SQL code
- Test Drive your Oracle database. Yes, it's doable. And it's fun!
- Test Driven Development in PLSQL with utPLSQL v3 - intro
- ruby-plsql cheatsheet
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
- utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part one
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part three - (not) reporting failures
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part two (setup and basic reporting)
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps ... continued
ci-cd¶
define default¶
error logging¶
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
exception handling¶
- BUG in INSERT ... SELECT with nested objects
- Beware of raise_application_error from within exception when others
- INSERT ... LOG ERRORS and SQL%ROWCOUNT
- INSERT ... LOG ERRORS and SQL%ROWCOUNT-continued
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
naming¶
rollback¶
ruby-plsql¶
- ruby-plsql cheatsheet
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
- utPLSQL v2 vs. ruby-plsql - exception handling
- utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part one
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part three - (not) reporting failures
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part two (setup and basic reporting)
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps ... continued
sonarsource¶
sqlplus¶
- SQL*Plus default values for script parameters
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
unit testing¶
- How I got into utPLSQL v3 development
- How I started to create Unit Tests for Oracle PL/SQL code
- Test Drive your Oracle database. Yes, it's doable. And it's fun!
- Test Driven Development in PLSQL with utPLSQL v3 - intro
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- ruby-plsql cheatsheet
- utPLSQL starter tips - Annotations configure tests
- utPLSQL starter tips - Testing for exceptions with --%throws
- utPLSQL starter tips - Testing query output with cursor comparison
- utPLSQL starter tips - The expectations API
- utPLSQL starter tips - creating test suite
- utPLSQL starter tips - reporting test results
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
- utPLSQL v2 vs. ruby-plsql - exception handling
- utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part one
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part three - (not) reporting failures
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part two (setup and basic reporting)
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps ... continued
utPLSQL¶
- How I got into utPLSQL v3 development
- Test Driven Development in PLSQL with utPLSQL v3 - intro
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- utPLSQL starter tips - Annotations configure tests
- utPLSQL starter tips - Testing for exceptions with --%throws
- utPLSQL starter tips - Testing query output with cursor comparison
- utPLSQL starter tips - The expectations API
- utPLSQL starter tips - creating test suite
- utPLSQL starter tips - reporting test results
utPLSQL v2¶
- utPLSQL v2 vs. ruby-plsql - Running Oracle unit tests on Jenkins CI
- utPLSQL v2 vs. ruby-plsql - exception handling
- utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part one
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part three - (not) reporting failures
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part two (setup and basic reporting)
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps ... continued