Developer Sam
  • Blog
  • About
  • Public Speaking

#100CodeExamples

#100CodeExamples

#100CodeExamples – Only one active protocol

For those who didn’t know: the death star runs on one of several protocols, but only one may be active at a time.
This can be easily achieved with simple tools most relational databases provide.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – Use the force to replace objects

Objects in oracle can be used to create nested table collections, which are accessible from SQL.
However, to change these objects once referenced by a table type can be very annoying unless you use the force.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types

#100CodeExamples: Cursor-comparison is one of the most powerful features of utPLSQL.
To model our expectation, we can not only use SELECT FROM DUAL but also the much more powerful user-defined types and Nested Table-collections.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings

#100CodeExamples – Implement some different force-sensitive beings with PL/SQL objects.
This is the first of several examples showing the object-oriented capabilities of PL/SQL.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – PL/SQL BOOLEAN to INT

#100CodeExamples – PL/SQL BOOLEAN to INT

For Oracle doesn’t know a BOOLEAN SQL-Type, we must find a smooth way to convert PL/SQL-BOOLEAN to INT

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – SYSDATE vs. CURRENT_DATE

#100CodeExamples – SYSDATE vs. CURRENT_DATE

I had a very strange problem yesterday where #utPLSQL cli showed different test outcomes than running the tests from my IDE. Here’s the reason.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – utPLSQL’s Suite Hierarchy in action

#100CodeExamples – utPLSQL’s Suite Hierarchy in action.

A great tool to structure tests, avoid duplication, give context and improve performance.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – Dynamic values in a String: UTL_LMS

#100CodeExamples – How to put dynamic values in a String with #PLSQL.
One possibility: the sys-package UTL_LMS

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison

#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with the Cursor Comparison capabilities of utPLSQL.

By Sam, 4 years ago
#100CodeExamples

#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

#100CodeExamples – A challenge to learn and teach.

My first example today: How to do a Primary/Replica lookup (in SQL) which I can query with the ID of any entry.

By Sam, 4 years ago

Posts navigation

Previous 1 2 3
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
Archives
  • 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