--- title: APEX SQL Workshop – a One-Stop Shop for APEX Development Projects? description: Discover the capabilities of APEX SQL Workshop and its potential as a one-stop solution for APEX development projects, compared to other development tools. image: https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20blog.png --- [![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk) [![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk) - Services - Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - Managed Services - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services) - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services) - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services) - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services) - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services) - Licensing and SAM - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services) - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam) - Application Services - [Application Development](https://www.dsp.co.uk/software-development) - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation) - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex) - [Application Extensions](https://www.dsp.co.uk/software-customisation) - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution) - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services) - [Development Training](https://www.dsp.co.uk/oracle-apex-training) - Data Science - [AI Strategy](https://www.dsp.co.uk/ai-strategy) - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai) - [Agentic AI](https://www.dsp.co.uk/agentic-ai) - [Data Management for AI](https://www.dsp.co.uk/data-management) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning) - Cloud Migration and Management - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment) - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation) - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration) - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services) - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management) - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure) - Integration and APIs - [API Management](https://www.dsp.co.uk/api-development-services) - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services) - Disaster Recovery and Security - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions) - [Security Compliance](https://www.dsp.co.uk/data-security) - [Cloud Security](https://www.dsp.co.uk/cloud-security)   ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg) #### Getting to know us - [About us](https://www.dsp.co.uk/about) - [What we do](https://www.dsp.co.uk/what-we-do) - [Leadership](https://www.dsp.co.uk/dsp-product-leads) - [Careers](https://www.dsp.co.uk/careers) - Technologies - Oracle Cloud Infrastructure - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services) - [IaaS](https://www.dsp.co.uk/iaas) - [PaaS](https://www.dsp.co.uk/paas-security) - Oracle Database - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting) - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services) - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - Oracle Engineered Systems - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy) - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance) - Oracle Applications - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services) - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services) - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services) - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services) - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services) - Microsoft - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Power BI](https://www.dsp.co.uk/power-bi-services) - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services) - Google - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner) - Multicloud and Database Hyperscaler - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner) - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning) - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws) - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud) - Open Source Database - [PostgreSQL](https://www.dsp.co.uk/postgresql-services) - [MySQL](https://www.dsp.co.uk/mysql-services) - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql) #### Managed Services - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services) - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services) - [MySQL](https://www.dsp.co.uk/mysql-support) #### Application Services - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration) - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) - [Microsoft](https://www.dsp.co.uk/microsoft-partnership) - [ISV Services](https://www.dsp.co.uk/isv-support-and-services) #### Cloud Services - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services) - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services) - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database) - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud) #### Data Science - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services) - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services) - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### Consulting Services - [Oracle](https://www.dsp.co.uk/oracle-consultancy) - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy) - [Google](https://www.dsp.co.uk/google-cloud-consultancy) - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations) #### Technology Solutions - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner) - [Data Security](https://www.dsp.co.uk/data-security) - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture) - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery) - Industries - [Finance](https://www.dsp.co.uk/finance) - [Healthcare](https://www.dsp.co.uk/healthcare-it-services) - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport) - [Higher Education](https://www.dsp.co.uk/higher-education) - [Public Sector](https://www.dsp.co.uk/public-sector) - [Manufacturing](https://www.dsp.co.uk/manufacturing) - [Retail](https://www.dsp.co.uk/retail) - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services) ### Recent case study: #### Oracle EBS Cloud Deployment Consolidating and Migrating assets into Oracle Cloud Infrastructure. [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)   #### Most Visited Pages - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing) - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/) - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration) - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services) - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services) #### - - [SQL Server Support](https://www.dsp.co.uk/sql-server-support) - [Oracle Support](https://www.dsp.co.uk/oracle-support) - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy) - [New Application Development](https://www.dsp.co.uk/oracle-apex-services) - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop) - Resources - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download) - [ISG](https://www.dsp.co.uk/isg-oracle-report) - [Blogs](https://www.dsp.co.uk/blogs) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - [Events](https://www.dsp.co.uk/events) - [Webinars](https://www.dsp.co.uk/webinars) - [Insights](https://www.dsp.co.uk/insights) - [Technical Resources](https://www.dsp.co.uk/technical-resources) ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.   [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305) #### Resources - [Blogs](https://www.dsp.co.uk/blogs) - [Webinars](https://www.dsp.co.uk/webinars) - [Case Studies](https://www.dsp.co.uk/case-studies) - [Testimonials](https://www.dsp.co.uk/testimonials) - About - [About DSP](https://www.dsp.co.uk/about) - [What We Do](https://www.dsp.co.uk/what-we-do) - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board) - [Careers](https://www.dsp.co.uk/careers) - [Project Harar](https://www.dsp.co.uk/project-harar) - [Customer Area](https://www.dsp.co.uk/contact-us) - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/) - [Customer Resources](https://www.dsp.co.uk/welcome) - [Contact us](https://www.dsp.co.uk/contact-us) # APEX SQL Workshop – a One-Stop Shop for APEX Development Projects? [ Michael Pickering ](https://content.dsp.co.uk/author/michael-pickering) 28-May-2025 13:29:24 APEX SQL Workshop – a One-Stop Shop for APEX Development Projects? 9:47 ### Contents [30-May-2024 16:53:36 Oracle APEX v SQL Developer for VS Code ](https://content.dsp.co.uk/oracle-apex-v-sql-developer-for-vs-code) [19-Feb-2025 12:51:03 Oracle APEX 24.2 General Builder Enhancements ](https://content.dsp.co.uk/oracle-apex-24.2-general-builder-enhancements) [23-Mar-2023 10:59:53 APEX Data Generator ](https://content.dsp.co.uk/apex-data-generator) In this blog, I will review the current capabilities of [APEX](https://www.dsp.co.uk/oracle-apex-services) Builder SQL Workshop and review to what degree a developer can use it exclusively on development projects. In recent years, the functionality of the APEX Builder, SQL Workshop, has evolved into a really usable tool for any PL/SQL development that may accompany an APEX project. However, in my team, at least, it’s rare that developers would work on a project and not use a third-party tool, such as Oracle SQL Developer, to do the bulk of the work when it comes to writing code, querying the database, executing DDL statements, etc. I thought it worth investigating whether we are at a tipping point yet where the inbuilt capabilities match these third-party tools and allow the developer to use APEX Builder as a ‘one-stop-shop’.   ## Examining SQL Workshop in APEX Builder SQL Workshops provide an excellent experience for most of the basic requirements that a developer might have when using such a tool. I.e. you fundamentally want to: - Navigate around and view database objects such as tables, packages, triggers, etc. - Interrogate the data itself by writing custom queries. - Script changes to database objects or update data itself. Using the object browser, you can pretty easily navigate around code-based objects and update them, view tables and their definitions and make modifications if required. [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%201.png?width=602&height=346&name=APEX%20SQL%20Workshop%20Image%201.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%201.png) Like most development kits, table definitions provide links to related objects, such as triggers and sequences. SQL workshop also makes it easy to download code – either as individual scripts via the object browser or in bulk (using the Generate DDL utility). SQL Workshop lays out the object browser in much the same fashion as other database tools would, allowing you to get a good overview of what’s in a particular schema. The list of object types is not as comprehensive as you would get in Oracle SQL developer. For example, there is no ability to create and manage database scheduler jobs – a feature that is essential if jobs are part of your project. The SQL command window is another major part of the SQL workshop.  [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%202.png?width=602&height=262&name=APEX%20SQL%20Workshop%20Image%202.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%202.png) Here, you can execute ad hoc SQL commands to interrogate data and run anonymous functions and procedures. You can access basic performance data on recently run statements as well as view the history of recently run commands. One feature I find particularly useful is the download option, which instantly puts the output of a query into a CSV in your download folder – something which is a little more fiddly in other tools.   One issue with using SQL commands for DML commands is the fact that, in recent versions of APEX, every statement is auto-committed. You should never be making unscripted direct changes to prod data or even accessing a Prod instance via the APEX builder, so most of the time, it isn’t a problem. However, it still makes me nervous if I’m modifying a small amount of test data – given that if I get it wrong (or don’t select the whole statement), I might end up modifying a LARGE amount of data by accident.  [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%203.png?width=518&height=248&name=APEX%20SQL%20Workshop%20Image%203.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%203.png) (oops…) Having the safety net of being able to roll back DML statements is useful when testing any DML functionality. The reason behind the auto-commit is due to security and the session-based nature of how APEX connects to the database, as it does not have a constant connection and therefore, a persistent session state is not maintained. It is the very web-based nature of the APEX/SQL Workshop tool which gives rise to most of the limitations of SQL Workshop. When developing, the ability to hop between viewing code, writing queries, examine tables is crucial. While it has improved greatly over the last few iterations, SQL Workshop still doesn’t really allow the fluidity of movement that other tools do. You have to do one thing at a time, as you can’t open multiple tabs. One common trick I use is to open two windows on the browser, one for Object Browser and one for SQL Commands. This works pretty well most of the time. However, you will run into problems if you try to have two object browsers open at the same time in the same session, for the same reasons that it’s not a good idea to open multiple tabs in the same APEX front-end app session – the web framework approach is just not designed to handle that. The ability to have multiple tabs and be able to navigate around packages and SQL worksheets etc., is crucial when developing code and third-party tools also for this more seamlessly than the APEX builder offering. One counterargument is, of course, that one may end up with far too many tabs open and that the fact that the SQL workshop doesn’t allow for this actually encourages a level of discipline that could lead to more productive working! Another area where the SQL Workshop doesn’t provide the optimum experience is when a project is version-controlled and has multiple developers. In our team, a standard rule to avoid losing work is to keep code in a version-controlled repository and then open it from that repository when it is being modified. This means that a developer is never just directly modifying the object on the database. So, if two developers modify the same package without realising, the second compilation will overwrite the first, but at least the code from the first won’t be lost. SQL Workshop doesn’t lend itself to working off local scripts. You can’t simply open a local file and compile it against the database like you can with other tools. Where the SQL Workshop shines is in certain areas over and above the basic functionality, generally within the SQL Utilities section. [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%204.png?width=602&height=207&name=APEX%20SQL%20Workshop%20Image%204.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%204.png) Utilities such as data workshop, data-generator and methods on tables seek to make the mundane elements of APEX projects (although not unique to APEX) much easier, such as basic DML, package creation, bulk data upload/download and test data generation. AI is being gradually plugged into the developer experience of APEX, and whilst there is not yet any intelligent predictive/auto-completion in the SQL Workshop like we have in the app builder, the capabilities of AI are being leveraged into the wider database functionality. A good example of this in the latest version of APEX (24.2) is [AI-Driven Data Modelling](https://blogs.oracle.com/apex/post/blog-create-data-model-using-ai). The ability to use AI to quickly generate sensible and normalised schemas for your project is far beyond what traditional client-based tools can achieve. In this case, the web-based nature of the APEX builder is an advantage rather than a hindrance. One can only assume in coming releases, the AI capabilities, in relation to development, will continue to grow.   ## Other tools – what they can do that APEX can’t (yet) I’ve already covered some of the basic things that SQL Workshop doesn’t do quite as well as other DB development tools. Now, I’ll look at a few common features that other tools have that might make them indispensable in certain projects. For the purposes of this blog, I have considered Oracle SQL Developer (OSD) and PL/SQL Developer (PSD) only (although honourable mentions for Toad and Visual Studio Code with Oracle plugins). One of the most notable advantages of OSD and PSD is the ability to navigate around multiple objects and tabs, as already mentioned. This advantage is extended when you consider the ability to move between multiple environments. By its very nature, APEX Builder focuses you on one workspace and the schemas within that. OSD/PSD allow you to have multiple connections at once, meaning if you are working in several environments during the day, you are not having to open multiple different windows. Much like the multi-tab experience, this isn’t always a good thing – with APEX, you know exactly where you are and there is no danger that you might apply code/updates, etc., to the wrong environment. However, having the flexibility to move between databases can be extremely beneficial in many circumstances. One example of this is the database diff feature in OSD, which allows you to do a full comparison of database objects across databases. [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%205.png?width=437&height=334&name=APEX%20SQL%20Workshop%20Image%205.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%205.png) Performance tuning is key for any database project. OSD/PSD provide far more options in terms of generating explain and execution plans, allowing you to analyse the performance of your code. This also extends to database session monitoring, which enables you to view and potentially even stop any long-running database processes. [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%206.png?width=602&height=225&name=APEX%20SQL%20Workshop%20Image%206.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%206.png) When a project involves debugging complex code, PSD has an invaluable tool, the step-through Debugger. If you have a lot of complex code with multiple levels of package calls, the Debugger can allow you to pinpoint exactly where something is failing or the output is not as expected. You can put breakpoints in code to run to a certain point. The step-through process allows you to control the execution of each line of code, so you follow the execution of a particular process through multiple procedures and functions. Another nice feature of PSD is the code beautifier, which can even be configured to your particular preference. [![APEX SQL Workshop – a One-Stop Shop for APEX development projects?](https://content.dsp.co.uk/hs-fs/hubfs/APEX%20SQL%20Workshop%20Image%207.png?width=472&height=298&name=APEX%20SQL%20Workshop%20Image%207.png)](https://content.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20Image%207.png)   ## Conclusion There is no doubt that SQL Workshop is an excellent feature of the APEX Builder and provides a great working environment for the bulk of an APEX developer’s needs. It will continue to grow, especially in the AI space, and one day could well be a one-stop shop for APEX development. If the project is relatively simple and doesn’t require large amounts of code objects, performance tuning or debugging, then it is a viable option, but, for anything else, I will be keeping my Oracle SQL Developer/PLSQL Developer applications on hand for a little while yet. For more information, check out our [Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services), and if you liked this blog, check out our other [APEX blogs here](https://content.dsp.co.uk/apex). [Contact us](https://www.dsp.co.uk/contact-us) today, and one of our expert developers will be in touch. [Oracle](https://content.dsp.co.uk/topic/oracle) [APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [SQL](https://content.dsp.co.uk/topic/sql) [30-May-2024 16:53:36 Oracle APEX v SQL Developer for VS Code ](https://content.dsp.co.uk/oracle-apex-v-sql-developer-for-vs-code) [19-Feb-2025 12:51:03 Oracle APEX 24.2 General Builder Enhancements ](https://content.dsp.co.uk/oracle-apex-24.2-general-builder-enhancements) [23-Mar-2023 10:59:53 APEX Data Generator ](https://content.dsp.co.uk/apex-data-generator) [Previous The Power of 24/7 Oracle Monitoring ](https://content.dsp.co.uk/the-power-of-24/7-oracle-monitoring) [Next Enhancing Oracle Database Monitoring with DSP ](https://content.dsp.co.uk/enhancing-oracle-performance-monitoring-with-dsp) #### Contact Sales Enquiries [+44 (0) 203 880 1686](tel:+4420%2038801686) Technical Support +44 (0) 330 058 8367 [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk) #### Follow us #### Office Locations [**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D) [Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D) [**Leeds** Richmond House, Lawnswood Business Park, Leeds, LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842) [**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) [DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D) ** [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)** [Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) [Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu) #### About Us DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies. ![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png) ![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png) ![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg) Registered Office: 30 City Road, London, EC1Y 2AB. Company Registration Number: 03898451 ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "dateModified" : "2024-10-01", "datePublished" : "2024-10-01", "headline" : "APEX SQL Workshop – a One-Stop Shop for APEX Development Projects?", "image" : [ "https://www.dsp.co.uk/hubfs/APEX%20SQL%20Workshop%20blog.png" ], "mainEntityOfPage" : { "@id" : "https://content.dsp.co.uk/apex-sql-workshop-a-one-stop-shop-for-apex-development-projects", "@type" : "WebPage" } } ```