Search

Top 60 Oracle Blogs

Recent comments

PL/SQL

A (Not So) Brief But (Very) Accurate History of PL/SQL

Preface PL/SQL is one of the top twenty programming languages in the world. While I’m no Matthew Symonds, and this is no Softwar, the history of PL/SQL deserves a helluva lot more than, “Oracle 7 had an advanced architecture and, like Sybase, was fully programmable via its elegant new PL/SQL programming language.” That’s why, during the process working on […]

The post A (Not So) Brief But (Very) Accurate History of PL/SQL appeared first on Oracle Internals.

A (Not So) Brief But (Very) Accurate History of PL/SQL

Preface PL/SQL is one of the top twenty programming languages in the world. While I’m no Matthew Symonds, and this is no Softwar, the history of PL/SQL deserves a helluva lot more than, “Oracle 7 had an advanced architecture and, like Sybase, was fully programmable via its elegant new PL/SQL programming language.” That’s why, during the process working on […]

The post A (Not So) Brief But (Very) Accurate History of PL/SQL appeared first on Oracle Internals.

Imitation is the Sincerest Form of Flattery

Compilers and Interpreters Compatible with PL/SQL The PL/SQL programming language, created by Oracle, is the most well-known database-oriented procedural language in existence. While everyone who knows about PL/SQL knows it’s available in the Oracle Database, what most people don’t know is that a number of companies and individuals have implemented their own compilers and interpreters […]

The post Imitation is the Sincerest Form of Flattery appeared first on Oracle Internals.

Imitation is the Sincerest Form of Flattery

Compilers and Interpreters Compatible with PL/SQL The PL/SQL programming language, created by Oracle, is the most well-known database-oriented procedural language in existence. While everyone who knows about PL/SQL knows it’s available in the Oracle Database, what most people don’t know is that a number of companies and individuals have implemented their own compilers and interpreters […]

The post Imitation is the Sincerest Form of Flattery appeared first on Oracle Internals.

Demystifying PL/SQL: The Life of a Compilation Unit

With a solid history of use, Oracle’s PL/SQL is one of the top twenty programming languages in the world. OverviewWhile many people tend to think of it strictly as a database procedural language, PL/SQL is far more powerful than most give it credit for. PL/SQL is so popular, in fact, that at least fifteen independent […]

The post Demystifying PL/SQL: The Life of a Compilation Unit appeared first on Oracle Internals.

Demystifying PL/SQL: The Life of a Compilation Unit

With a solid history of use, Oracle’s PL/SQL is one of the top twenty programming languages in the world. OverviewWhile many people tend to think of it strictly as a database procedural language, PL/SQL is far more powerful than most give it credit for. PL/SQL is so popular, in fact, that at least fifteen independent […]

The post Demystifying PL/SQL: The Life of a Compilation Unit appeared first on Oracle Internals.

Video : Returning REF CURSORs from PL/SQL : Functions, Procedures and Implicit Statement Results

Today’s video is a demonstration of returning REF CURSORs from PL/SQL using functions, procedures and implicit statement results.

Video : SQLcl and Liquibase : Automating Your SQL and PL/SQL Deployments

In today‘s video we’ll give a quick demonstration of applying changes to the database using the Liquibase implementation in SQLcl.

The video is based on this article.

You might also find these useful. The secure external password store is a good way to make connections with SQLcl. If you support a variety of database engines, you may prefer to use the regular Liquibase client.

Video : Decoupling to Improve Performance

In today’s video we demonstrate how to cheat your way to looking like you’ve improved performance using decoupling.

This was based on the following article.

This came up in conversation a few days ago, so I thought it was worth resurrecting this demo. It doesn’t really matter what tech stack you use, the idea is still the same.

Automating SQL and PL/SQL Deployments using Liquibase

https://oracle-base.com/blog/wp-content/uploads/2019/12/sqlcl-295x300.png 295w, https://oracle-base.com/blog/wp-content/uploads/2019/12/sqlcl-57x57.png 57w" sizes="(max-width: 189px) 85vw, 189px" />

You’ll have heard me barking on about automation, but one subject that’s been conspicuous by its absence is the automation of SQL and PL/SQL deployments…