Developer Sam
  • Blog
  • About
  • Public Speaking

#100CodeExamples

#100CodeExamples

Well-Testable Code: Dealing with the “Popular Sith”-Sequence

My last example of controlling a sequence to test some default-behavior was not “well-testable” PL/SQL code.
In this example I show how we can achieve a method that is much easier to test, doesn’t require touching internals – all without changing the public API of the method.

By Sam, 3 years ago
#100CodeExamples

utPLSQL and ORA-04061 – Global State and Package Invalidation

A combination of Package global state and Package invalidation can easily lead to ORA-04061 errors, especially in unit-testing situations.
This blog-post explains the problem and shows possible solutions (all with examples)

By Sam, 3 years ago
#100CodeExamples

Let Tests Tell a Story With utPLSQL Nested Contexts

Unit-Tests are automated checks of certain behavior. But what if we could also use them to describe what the functionality they’re checking is supposed to do?

By Sam, 3 years ago
#100CodeExamples

OGB Appreciation Day: Explore a utPLSQL test scenario with “force-manual-rollback”

How to explore some functionality you don’t know but want to change or improve?
Write a unit test with utPLSQL and use the force-manual-rollback param!
#ThanksOGB

By Sam, 4 years ago
#100CodeExamples

Concatenate a List of Strings in PL/SQL

How to concatenate a list of Strings in PL/SQL?
This blog-post shows 4 different approaches.

By Sam, 4 years ago
#100CodeExamples

PL/SQL Object Types: putting the Structure into the Force Powers Table

Object Types are a very useful thing when used in PL/SQL, but Oracle even allows us to have them inside a table.
Let’s see how we can put the numeric_strucutre-logic inside the Force Powers table and use indizes on the new column.

By Sam, 4 years ago
#100CodeExamples

Structure Force Powers with PL/SQL Object Types

Modern SQL and especially PL/SQL is turing complete and can be used to solve every problem, but Oracle SQL Types can help greatly to do it in a much more readable way.

By Sam, 4 years ago
#100CodeExamples

Narrate Star Wars Movies with utPLSQL annotations

Did you know you can narrate the story of the Star Wars movies with utPLSQL annotations?
In this blog post I show you how and list 4 takeaways you might not have known.

By Sam, 4 years ago
#100CodeExamples

More Pitfalls of the MINUS comparison

Comparing the results of 2 queries is a task more complicated than I thought initially.
I show some more pitfalls of the MINUS approach (which I still find convenient in some cases) and alternatives.

By Sam, 4 years ago
#100CodeExamples

Testing the Deathstar security with utPLSQL contexts

The context-feature of #utPLSQL can greatly help to organize your tests and reduce the setup/teardown time of tests.
Learn how to use them to test the Deathstar security system.
#100CodeExamples

By Sam, 4 years ago

Posts navigation

Previous 1 2 3 4 Next
Tags
#100CodeExamples AdventOfCode2020 Agile APEXConnect Charset CheatSheet Clarity Clean Code Compassione Coding Conferences Continuous Integration Decision Making DesignRules DOAG Don't Repeat Yourself Dunning-Kruger-effect EDD Empathy Evolutionary Fun JavaScript Learning Life Migration MINUS Oracle OracleACE Personal Growth PL/SQL Public Talking Puzzle Readability Reflection Self-Awareness Self-Testing Software Design Software Quality Speaking SQL SQL Types TDD Team Testing Unit-Testing utPLSQL
Categories
  • #100CodeExamples
  • Advent Of Code 2020
  • BeckDesignRules
  • Book Club
  • Fun
  • Humans
  • Java
  • Oracle ACE
  • PL/SQL
  • Programming Concepts
  • Public Speaking
  • Reflections
  • SQL
  • Testing
  • Tooling
  • Uncategorized
  • utPLSQL
  • Virtual Presenting
Archives
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • July 2022
  • May 2022
  • December 2021
  • July 2021
  • June 2021
  • March 2021
  • February 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • April 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • September 2018
  • August 2018
  • June 2018
  • May 2018
  • March 2018
  • January 2018
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • May 2016
  • Imprint / Impressum
  • Contact
Hestia | Developed by ThemeIsle