SERPland Blog

2025

PL/SQL Function Hash Algorithm - Oracle Hash Value
With Oracle10g Database many new features on case-, accent- and linguistic idependent query and sort functions
Oracle Designer TAPI: Calling the select (slct) procedure via pl/sql
Quest TOAD 10. ERROR on startup toad.exe: No argument for format '%s'

2024

Oracle Service Bus Tutorial: basing dbAdapter on Nested Object Type (Master-Detail)
pl/sql integer stack with object types
Calculate next (this) friday date with pl/sql - hide out!
TO_CHAR Oracle Function
Oracle Sum Function
Template Method Pattern implemented in PL/SQL
Oracle SQL: Summarize a calculated column (like a count(*) column) with ROLLUP

2023

Oracle Forms Source Control / Concurrency Control
Decorator Design Pattern in Oracle PL/SQL: Using Object Type with Constructor
Value analysis - Oracle Designer Forms Generator vs. Native Oracle Forms Developer (Nutzwertanalyse)
First steps to install SOA Tool #1: Oracle SOA Suite
Oracle SQL Error: ORA-04052 error occurred when looking up remote object (ora-604/ora-2019)
Oracle Forms Error: PDE- .... INTERNAL ERROR. Unable to adjust forms for output .....
CASE expression in Oracle SQL statement
avaloq cost rule: commstex swx buy sell prozent menge betrag
mySql visual/graphical data modelling tool to generate database tables - free - use mySql Workbench
Netbeans vs. JDeveloper

2022

business rules editors and topology
SQL Befehle Übersicht | SQL Befehl Liste
Oracle and XML: works with Oracle9i, 10g, 11g and higher
Oracle Reports: Long running PDF Report crashes (rw.dll)
SQL: Remove Strings or Letters

2021

Eclipse and Ant Build: deploy everything with!
Naming and Coding Standards for SQL and PL/SQL - Some things I cant agree
Oracle Service Bus Documentation
OSB XQuery Exception FORG0005: expected exactly one item, got 0 items
uml inheritance diagram: oracle numeric datatypes
Essay - Abhandlung: Steven Feuersteins Best PL/SQL Practices und TOAD Code Tester
SQL Trace with Oracle Database
Oracle PL/SQL: VARRAY (Collection) manual filling and reading for processing

2020

pl/sql: exit an enclosing loop (leaving a labeled loop)
D: Dokumentation TOAD for Oracle (Datenbank Werkzeug)
Oracle Reports and Forms SSL (HTTPS) calls
Oracle Reports Query not linkable: REP-20147 error (group link)
using the anydata datatype in oracle
why nobody uses Oracle's PL/SQL language
MYSQL Error #1932 Table doesn't exist in engine
Oracle Forms: How to change an item to bold during runtime
PL/SQL Tutorial w3schools.com?
PL/SQL: Merge Statement - Merge into a single table (no Join to insert or update) - like mySQL upsert
Design Patterns in PL/SQL (Oracle)
Toad 9 default options which should be changed
Recent: Microsoft azure cloud
Recent: Java jsp
Recent: Oracle
Recent: Internet
Recent: Legoland
Recent: Lifestyle
Recent: Misc
Recent: Rsi
Recent: Pool
Recent: Cast application mining
Recent: Bungalow familien hotels
Recent: Deutsch
Recent: No tube graz
Recent: Rare earth elements metals
Recent: Android hdr
Recent: Soa
Recent: Garten
Recent: Ferien
Recent: Abendkleider verleih
Recent: Seltene erden
Recent: Foto
Recent: Cruise lines
Recent: Handy
Recent: Wordpress
Recent: Treasure research
Recent: Pelorus
Recent: Va bene
Recent: Finance
Recent: Zurich
Recent: Schwebetuerenschrank
Recent: Electronics
Recent: Transport travel
Recent: Sport
Recent: Regional
Recent: Baubiologie
Recent: Kinder
Recent: Baseball
Recent: Avaloq