The Analyst Geek

PL/SQL blocks and variables

May 3, 20232 min read

PL/SQL blocks are groups of one or more SQL or PL/SQL statements that are enclosed within a BEGIN and END block. PL/SQL variables are used to store...

PL/SQL blocks and variables

PL/SQL Key topics to learn.

May 3, 20232 min read

PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL that enables developers to write procedural code and implement business...

PL/SQL Key topics to learn.

Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].

Nov 10, 20212 min read

Over() It is a similar thing to group by but instead of shrinking the table it initializes the value in front of each column & gives its results in...

Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].