Thursday, November 09, 2017

Write Once, Run Anywhere: PL/SQL Comes to Yet Another Database

DZone Database Zone
Write Once, Run Anywhere: PL/SQL Comes to Yet Another Database
Write Once, Run Anywhere: PL/SQL Comes to Yet Another Database

Back in the late 1980s, some big brains at Oracle realized that an OS-independent language was needed to build applications on top of Oracle Database (and our SQL implementation). Their rapidly growing customer base was writing applications in C (making calls to SQL via the OCI layer), and that was problematic. Code needed to be ported, re-tested, etc. for variations of the C compiler on different systems — and C wasn't very easy to write.

They dreamed of programs running inside the database itself that could be moved from operating system to operating system and not require any changes.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...