SMART4Solutions
  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy

SMART4Solutions on Oracle APEX

PL/SQL

A good example of PLSQL-OO

I am a PL/SQL nerd. I love the language and what you can do with it. I consider myself a PL/SQL programmer first and only secondarily an APEX developer. For quite some time now I am highly in favour of Read more…

By Richard Martens, 4 months7 April 2022 ago
APEX Database JoelKallmanDay

ORA-06502: When loading data in the APEX data-loader

My contribution to this years contribution to #JoelKallmanDay Recently I created a data-load within APEX to load about 3500 lines of excel-sheet into a temporary table. I created the table for receiving the data using the Data Workshop, as shown Read more…

By Richard Martens, 10 months11 October 2021 ago
APEX

Consume Digest API with PLSQL

In my personal blog, I have created an digest authenticated API use nodejs. Only thing it does is to authenticate with digest and output a json string when you are authenticated. I made it so that I can consume it Read more…

By Chao Yu, 1 year24 July 2021 ago
APEX

Google Analytics: custom dimensions

Google Analytics allow developers to collect custom data (parameters) and create custom dimensions to make use custom data. In this blog, i will try to go through the steps of creating custom dimensions and make use of the custom dimensions. Read more…

By Chao Yu, 1 year16 July 2021 ago
APEX

Connect Google Analytics to your APEX application

prerequisite: Any APEX application you have access to Google Account Go to google analytics ( make sure you have google analytics enabled ) and then go to the following section of the admin page and click on Create Account Once Read more…

By Chao Yu, 1 year14 July 2021 ago
APEX OraCloud

Adding a login-message to your always free Oracle Cloud APEX instance

I used Dimitri’s great blog on how to get started on the Oracle Always Free cloud and APEX. Great work Dimitri.. Thanks for this. We’re used to add a login-message to our instances, so we can easily see on what Read more…

By Richard Martens, 3 years9 November 2019 ago
Database OraCloud

OCI connections to multiple Autonomous Transaction Databases in the Oracle Always Free cloud

I still use PL/SQL developer to work in our Oracle Databases. It is a tool I’ve been using for years and old habits seldom die.. In fact Pl/SQL developer is the only sound reason I have parallels desktop installed on Read more…

By Richard Martens, 3 years8 October 2019 ago
APEX JavaScript PL/SQL

And that’s how the cookie crumbles

owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.

By Richard Martens, 4 years1 November 2018 ago
APEX PL/SQL

On APEX LOV’s and how to define their queries

The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.

By Richard Martens, 4 years13 October 2018 ago
Database

Make tomcat wait until oracle database is available

Recently I’ve been installing the OATOA (Oracle APEX on Tomcat with ORDS behind Apache) stack a number of times on both Oracle Linux 7 and CentOS7. In the past this was no problem, Tomcat came up and a request to Read more…

By Richard Martens, 4 years5 October 2018 ago

Posts navigation

1 2 Next
Categories
  • APEX (10)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (3)
  • Presentations (2)
Archives
  • April 2022
  • October 2021
  • July 2021
  • November 2019
  • October 2019
  • May 2019
  • November 2018
  • October 2018
  • March 2016
Follow Us On Twitter
  • Richard Martens
  • Sergei Martens
  • Robert Van Leenders
  • Kevin Rütten
  • Chris Jansen
Interesting Links
  • SMART4Apex
  • SMART4Branding
  • SMART4Solutions
  • Privacy Policy
Categories
  • APEX (10)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (3)
  • Presentations (2)

  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy
Hestia | Developed by ThemeIsle
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.

Settings Reject Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy