logo



Our Services


At Bond & Pollard we understand that you cannot afford to take risks with your mission critical business systems. Our extensive experience of developing custom applications for the Oracle E-Business Suite will ensure that your projects are completed successfully, on time, and on budget.
We are highly experienced with AI, and migrating legacy applications to Oracle 26ai and APEX.
Our Blog gives a step-by-step guide to building an Oracle application using the PL/SQL programming language. There's an open-source application for you to download, with error logging, data exchange, and commonly used functions to search data and calculate statistics.

GitHub Repo
Open source, free-to-use PL/SQL

If your business needs expert Oracle contractors then please contact us to find out how we can help.

Full Life-cycle Support

Our experienced consultants will support your projects through every stage of the Life Cycle.

Oracle Database 26ai

Database design for custom application extensions, fully compliant with Oracle standards.

Oracle Applications

Oracle EBS R12: Forms, Reports, PL/SQL, SQL*Plus. Fully compliant with Oracle customization standards.

Testing

Test planning. Test scripts. Bug reporting and fixing.


Documentation

Comprehensive documentation conforming to Oracle Application Implementation Methodology

Implementation

Oracle Unified Method. Risk Planning, deployment scripting and code deployment.

Additional Services

Data Migration (ETL). C, C++, COBOL, PowerHouse 4GL, Pascal, VAX BASIC.


Support

Applications maintenance and support. Legacy System Support. Data Recovery in partnership with Fields DATARECOVERY.

Insurance Backed

All our work is guaranteed and insurance backed.

 

About Us

Bond & Pollard Limited is a British IT services company, incorporated in 2008. With Bond & Pollard you are assured a first class service, provided by a team of highly trained professionals, with the full support of an established UK company.


Oracle EBS Experts

Our team of developers have acquired several decades of experience working as IT professionals across a wide range of industry sectors, and specialize in Oracle E-Business Suite customizations.


Oracle AI

We have the skills and experience to help you upgrade to Oracle 26ai, and migrate your legacy Forms and Reports applications to AI-enabled APEX,


Legacy IT Skills

With more than thirty years' experience in the IT industry, our consultants have a wealth of skills and knowledge. In addition to being experts with modern programming languages and AI, we retain the skills required to maintain legacy systems; COBOL, PowerHouse 4GL, C/C++, VAX BASIC. We can help you to keep your legacy systems up and running whilst you make the transition to Oracle EBS.


Locations Covered

We are based in Buckinghamshire and West Yorkshire. Our consultants are happy to travel and work anywhere in the UK or Europe. We've spent years doing this kind of work and love to get out and meet our clients.

IT Desk /> </div class=

Our Portfolio


Our consultants have gained extensive experience developing business software for many multinational companies, operating across a wide range of industry sectors.

Financial Services

Car Care Plan
GMAC
Provident Insurance

Manufacturing

British Steel
Craven Fawcett
Johnson Radley

Logistics / Transport

Rhenus Logistics
Hays
Haywood

Electronics / Telecoms

Pace plc



Education

Manchester Metropolitan University

IT Services

Fraser Williams
FWL Liverpool
M 'n' G Designs

Chemicals

Ciba-Geigy
Clayton Aniline Co.

Grocery / Wholesalers

Farmfoods
Goodness Foods
Icelandic
Palmer & Harvey

Food & Beverage

Samuel Smith

The Team

Our team of developers are highly experienced IT professionals, with in-depth Oracle skills.

Ian Bond

Director & Oracle Technical Consultant

Prior to joining us, Ian spent ten years at Pace plc where he was the Oracle Development Team Leader, responsible for installing, customizing and upgrading the E-Business Suite applications.

CV download

Liz Pollard

UI/UX Designer

Liz, a talented designer and artist, ensures that the user interface is intuitive, logical, and visually harmonious.

Oracle 26ai

Database design

Oracle EBS R12

Customization

Support

Full project life-cycle

Blog Posts


Introduction

Welcome to our Blog. The following posts give tips and techniques for application development.

  • Start with a Read Me that guides you through installing Oracle 26ai.
  • Download and install an application with open-source, production ready PL/SQL code: error logging, data import/export, searching, statistics, date functions (first and last working days of month), sort, remove duplicates, reverse lists, etc.
  • Topics covered in the Read Me: Systems Development Life Cycle, Application and Database Security, Developing Modular Database Applications, Database Design, Coding Standards, and PL/SQL Programming Tips.
  • Follow the Blog to build a series of PL/SQL functions that come together to make a working application.



Key Features

  • This high-quality technical blog walks developers through the design and implementation of each component. Every blog post links directly to the source code in our GitHub repository.
  • The open-source code is practical, efficient, and immediately usable in real Oracle E-Business Suite, APEX, or custom database environments.
  • The statistical library and utility packages are the kind of “build-once, use-everywhere” assets that save development teams significant time, and reduce long-term maintenance costs.

PL/SQL Best Practices

  • Code consistently follows, and in many cases exceeds, the standards set by Steven Feuerstein, the Trivadis PL/SQL & SQL Coding Guidelines, and Oracle SQL Developer formatting conventions.
  • Packages are modular, well-named, and fully documented, with centralised constants, robust error handling via a reusable logging utility, and zero tolerance for anti-patterns such as silent WHEN OTHERS handlers.

Production-Grade Deliverables

  • Comprehensive, reusable PL/SQL utility framework.
  • Full-featured statistical library (frequency tables, mean, median, mode, percentiles, variance, standard deviation, etc.) that works from arrays, comma-separated lists, or CSV data.
  • Utility packages for numeric, string, date, file I/O, and administrative functions such as error logging.
  • CSV import/export handling, binary search routines, and holiday/workday calculation.
  • All of this is delivered as clean, installable packages with extensive headers, modification histories, and a complete demo schema based on an extended Scott/Tiger environment.

Please feel free to use the open-source code in our GitHub repository for your own projects
GitHub Repo
Oracle Demo - Open source, free-to-use

If you need experienced PL/SQL developers then please contact us


Blog Index
Demo App

Demo Oracle Application

23 July 2022 in PL/SQL

In today's blog, we take a look at getting started with Oracle Database, and creating a demo application.



Normalization

Database Normalization

30 July 2022 in Database Design

What is normalization? Let's have a look at designing a set of normalized database tables for our demo application.



Log Message

Application Message Log

7 August 2022 in PL/SQL

In today's blog we create a PL/SQL procedure that our demo application will use to log messages.



CSV Field Extract

Delimited String Field Extract

14 August 2022 in PL/SQL

In this post we look at a handy string function to extract fields from CSV type records, solving the problems of different delimiters, and embedded quotes in fields that are surrounded with quotes.



CSV Import

CSV File Data Import

5 May 2023 in PL/SQL

Today's blog demonstrates a PL/SQL application that imports sales order data from CSV files into the Oracle database. The demo application contains some ready-made PL/SQL packages to handle the process of loading data from CSV format files into staging tables, logging errors, and moving processed files. In the previous blog we looked at a function to extract individual fields from CSV records, and we will use this for our import process.



CSV Export

Export Orders to a CSV File

15 May 2023 in PL/SQL

In this post, we take a look at a PL/SQL function that exports data from the Oracle Database to a CSV file.



Numeric Functions

PL/SQL Fun with Numbers

13 February 2024 in PL/SQL

A look at numeric functions in PL/SQL, with example source code: Binary search, base conversion, alphanumeric code (Excel column labels A-Z,AA,AB...), factorials, sort, remove duplicates.



Date Functions

PL/SQL Date Functions

13 February 2024 in PL/SQL

Here we look at some useful PL/SQL date functions: finding the date of Easter, and related holidays for any year. Is this is working day?



APEX Install

Oracle APEX Installation on Windows

15 September 2025 in APEX

In this blog post we will install the full Oracle Application Express APEX development environment on Windows. This installation will deploy Oracle REST Data Services ORDS on Apache Tomcat server.



Binary Search

Binary Search

27 February 2026 in PL/SQL

Binary search functions in PL/SQL, including: rightmost, leftmost, nearest, predecessor, successor, range, and rank.



Statistics

Statistical Library

27 February 2026 in PL/SQL

Design and implementation of a library of PL/SQL functions to convert an array into a frequency table, and compute statistics: sum, count, mean, median, mode, lowest, highest, range, variance, standard deviation, interquartile range, percentile.



Statistics

Generate Stats from CSV Data

18 March 2026 in PL/SQL

Generate statistics using data imported into Oracle from CSV files.

Load More

Contact Us

If you need experienced Oracle Technical contrators for your project, then please get in touch using the form below.

Based in West Yorkshire, we provide Oracle consultancy services across the UK and Europe.