AMAniket Marwadeindatagyan.hashnode.dev·May 3, 2023 · 2 min readPL/SQL blocks and variablesPL/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...00
AMAniket Marwadeindatagyan.hashnode.dev·May 3, 2023 · 2 min readPL/SQL Key topics to learn.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 ...00
AMAniket Marwadeindatagyan.hashnode.dev·Nov 10, 2021 · 2 min readUnderstand over() clause in comparison with group by and equivalent code [using inner join and subquery].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...00
