You are here

Home

pl/sql

MariaDB sql_mode = 'oracle'

Thu, 2021-03-25 20:15 — Shinguz
Taxonomy upgrade extras: 
Oracle
mariadb
pl/sql
sql_mode

MariaDB has some time ago introduced or reused the sql_mode = 'oracle'. What they basically try to do is to implement a subset of the Oracle PL/SQL language. Because we receive more and more request from customers about MariaDB's Oracle PL/SQL it is worth investigating a bit more in this feature and summarize the state of the art of this topic in this article.

See also our former articles about the MariaDB sql_mode = 'oracle':

MariaDB PL/SQL Examples

Table of Contents


Before you start

SQL> SET SESSION sql_mode='ORACLE';

Infinite Loop Example

DELIMITER /

BEGIN

LOOP
  SELECT 'Hello world from MariaDB anonymous PL/SQL block!';
END LOOP; 

END;
/

DELIMITER ;

Undefined
tags: 
mariadb
example
application
programming
pl/sql
Oracle

Select Hello World FromDual with MariaDB PL/SQL

Tue, 2018-06-12 23:36 — Shinguz
Taxonomy upgrade extras: 
mariadb
pl/sql
package
procedure
function
Oracle

MariaDB 10.3 was released GA a few weeks ago. One of the features which interests me most is the MariaDB Oracle PL/SQL compatibility mode.

So its time to try it out now...

How good is MySQL INSERT TRIGGER performance

Wed, 2011-08-03 17:08 — Shinguz
Taxonomy upgrade extras: 
english
mysql
benchmark
performance
trigger
innodb
myisam
insert
pl/sql
SQL/PSM

Abstract: In this article we discuss how big is the performance impact of MySQL TRIGGERs compared to application side logging (with INSERT) into a MySQL table.

Subscribe to RSS - pl/sql