Tags¶
Following is a list of relevant tags:
CI/CD¶
ERRORLOGGING¶
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
- 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
- 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
- Test Drive your Oracle database. Yes, it's doable. And it's fun!
- 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/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)
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 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!
- 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
- utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec - part two (setup and basic reporting)
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¶
- How I started to create Unit Tests for Oracle PL/SQL code
- 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)
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!
- 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
Test Automation¶
UTPLSQL¶
- How I got into utPLSQL v3 development
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- 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
define default¶
error logging¶
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
exception handling¶
rollback¶
- SQLPlus ERRORLOGGING does not keep error log on rollback
- SQLPlus ERRORLOGGING issues with error log on rollback resolved
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
sql¶
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
- Test Drive your Oracle database. Yes, it's doable. And it's fun!
- What is the equivalent of utassert eqtable / eqquery in utPLSQL v3
- 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