PL/SQL

Machine Learning, PL/SQL, SQL

Looking for AI? You already have it!

April 23, 2024

These days I meet many people who talk about how they have a project to find an AI-plattform to use on-premises. Using it in the cloud on Autonomous it is pretty obvious that you use one in a handful of AI-services Oracle has at your disposal there. The question is what you should use to…
Read more: Looking for AI? You already have it!
Oracle, PL/SQL, SQL

Using package variables in SQL

April 6, 2023

I often want to use the constants defined in packages also in my SQL. It has in the past never worked and it for the most part still does not. If I have a a package like this to simplify my code for what department it is I’m looking at. This now allows using dept_info.c_accounting…
Read more: Using package variables in SQL
Oracle Cloud, PL/SQL, SQL Developer

Debugging in cloud or datacenter

December 22, 2020

Unable to debug due to clouds or firewalls in your datacenter? No more, SQL Developer 20. 2to the rescue.
Read more: Debugging in cloud or datacenter
PL/SQL, SQL

Accessing a website from the database

April 15, 2020

One of the things people want more and more often is to somehow read from a web-resource using a database. It could be to just get the HTML off of a website or access REST via PL/SQL, or grab a JSON-file residing on a public website. No matter which it is we need to declare that…
Read more: Accessing a website from the database
PL/SQL, SQL

LUHNs algoritm – Three ways with SQL and PL/SQL

February 25, 2020

Have you encountered LUHNs algorithm? I can almost guarantee it even if you’ve never heard the name before. It is part of all of our lives every single day. It is used to check that various numbers are correctly entered. From ID numbers for persons in Sweden, Greace, and Israel to credit card numbers and…
Read more: LUHNs algoritm – Three ways with SQL and PL/SQL
APEX, Oracle, PL/SQL, SQL

The power of using records in APEX III

March 15, 2013

In this post I’ll finish up the CRUD implementation using records, procedures and views. This series of blog posts started with this post which was followed by this. At this point we have a working report that links to a form. The report is based on a view and the form is based on a procedure.…
Read more: The power of using records in APEX III
APEX, PL/SQL

The power of using records in APEX

October 24, 2012

Do you use forms based on procedures in APEX? If not, why not?Do you use records in the procedures you use for forms in APEX? If not, why not? I like procedures and records and with APEX I like them even more. Why you say? Should you not just point forms against tables and let…
Read more: The power of using records in APEX

Subscribe

Sign up with your email address to receive our weekly news

Latest news

Categories

Search