Coding Supply

Everything a Programmer Needs

What’s the difference between PL/SQL and SQL?

Updated: Leave a Comment

What’s the difference between PL/SQL and SQL?

If you’ve been doing some work on Oracle databases or just learning more about the RDMS, at some point you’re going to stumble across PL/SQL, or “Procedural Language/SQL“. Most programming curriculum I have seen never touches on anything like PL/SQL so it often comes as a complete surprise – so what exactly is PL/SQL, and how does it differ from SQL?

A Straight Forward Explanation of PL/SQL for Beginners

PL/SQL is basically a programming language that exists on Oracle SQL Servers. It can be viewed as an extension of SQL, offering much greater control over the data in the database and how you interact with it. Other RDMS tend to have their own, similar but very different procedural programming languages like Microsoft SQL Server’s T-SQL and Posgres’ PL/pgSQL.

[Read more…]

Learn Simple Encryption in Ruby

Updated: Leave a Comment

Learn Simple Encryption in Ruby

As long as there has been civilization and written language, there has been a need for encryption. Encryption is basically the act of disguising your message so that (hopefully) only the intended recipient can read it.

While you likely associate encryption with internet protocols and WiFi passwords today, there’s a very long and interesting history of encryption dating back to ancient times. I recently read a fascinating history of cryptography called The Code Book by Simon Singh.

While the book is a bit dated in terms of modern cryptography (it was published in 2000, so don’t expect anything about blockchain), it’s still a fantastic read that I would recommend to any programmer.

Coding a Caesar Shift

The most basic and ancient example of cryptography is the “Caesar Cipher“, or “Caesar Shift”. You’ve probably created your own Caesar Cipher as a kid without even knowing the name or history of it. The basics of it are this

[Read more…]