---
title: "Aniket Marwade (@aniketmarwade0) | Hashnode"
description: "write what you learn. Read the latest articles by Aniket Marwade on Hashnode."
url: "https://hashnode.com/@aniketmarwade0"
---

@aniketmarwade0

# Aniket Marwade

@aniketmarwade0 · Joined November 2021

write what you learn

### [PL/SQL blocks and variables](https://datagyan.hashnode.dev/plsql-blocks-and-variables?utm_source=hashnode&utm_medium=feed)

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 values that can be referenced and manipulated within a PL/SQL block. Here is an example of a simple PL...

2 min read · [datagyan.hashnode.dev](https://datagyan.hashnode.dev/plsql-blocks-and-variables?utm_source=hashnode&utm_medium=feed)

[May 3, 2023](https://hashnode.com/posts/plsql-blocks-and-variables/645294b87a77afc14baf1051)

### [PL/SQL Key topics to learn.](https://datagyan.hashnode.dev/plsql-key-topics-to-learn?utm_source=hashnode&utm_medium=feed)

PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL that enables developers to write procedural code and implement business logic within an Oracle database. Here are some of the key topics to learn in PL/SQL: PL/SQL blocks ...

2 min read · [datagyan.hashnode.dev](https://datagyan.hashnode.dev/plsql-key-topics-to-learn?utm_source=hashnode&utm_medium=feed)

[May 3, 2023](https://hashnode.com/posts/plsql-key-topics-to-learn/64529283a6ad884dbfd5502c)

### [Understand over() clause in comparison with group by and equivalent code \[using inner join and subquery\].](https://datagyan.hashnode.dev/understand-over-clause-in-comparison-with-group-by-and-equivalent-code-using-inner-join-and-subquery?utm_source=hashnode&utm_medium=feed)

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 front of every row.. Group by only gives aggregated columns, other columns are not shown while we u...

2 min read · [datagyan.hashnode.dev](https://datagyan.hashnode.dev/understand-over-clause-in-comparison-with-group-by-and-equivalent-code-using-inner-join-and-subquery?utm_source=hashnode&utm_medium=feed)

[Nov 10, 2021](https://hashnode.com/posts/understand-over-clause-in-comparison-with-group-by-and-equivalent-code-using-inner-join-and-subquery/618bde12468c06249afc6762)
