SQL Articles

SELECT INTO Statement in PL/SQL

In the previous tutorial, we learned what is PL/SQL as well as how to write a sample PL/SQL code. There we saw that PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. In this article, we will learn how to use SELECT INTO statement to retrieve data of a single row from a database and assign the selected values into variables.PLSQL SELEC

SQL June 27, 2020
What is Oracle PL/SQL? - An Introduction

In the previous article, I introduced you to MS SQL Database. In this article, I will introduce you to Oracle PLSQL. And at the end of the tutorial, you will learn about PLSQL language as well as its architecture.PLSQL combines SQL along with procedural features of programming. PLSQL stands for Procedural Language extensions to the Structured Query. It was created by Oracle Company in the 1990s to

SQL June 21, 2020
Introduction to SQL Server - Most Important SQL Queries

Today, data is the basis of any business out there. Big enterprises do data-driven businesses. This data needs to be stored in well-structured storage facilities called database. Therefore in this article I shall focus on teaching you the most important SQL Server commands.  Structured Query Language. SQL is used to communicate with a database. You can use the commands in other relational DBM

SQL May 24, 2020
Pages