Developer Sam
  • Blog
  • About
  • Public Speaking

XML

#100CodeExamples

XML-Generation in SQL with Namespaces

One of my favorite features of (Oracle-)SQL is how easy it is to turn relational data into other data formats like JSON or XML.
But what if you need to add a namespace to some of the nodes in your generated XML?
I struggled with that until I made a realization about the nature of the xlmns part in XML.

By Sam, 2 monthsFebruary 3, 2023 ago
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
  • 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