PL/SQL TUTORIAL Archives - Wings Of Technology

SQL Procedural Language (T-SQL) Performance Considerations

Admin May 9, 2021 PL/SQL TUTORIAL, SQL TUTORIAL

In this post, we discuss what are the things we need to keep in mind while stored procedures in SQL Server when it comes to performance and best practice. …

[Continue Reading...]

ORACLE : GET RECORD COUNTS OF ALL TABLES IN A SCHEMA

Admin September 19, 2019 PL/SQL TUTORIAL, SQL TUTORIAL

METHOD-1: The below query will give a number of rows for the required tables but these are not accurate until we ANALYZE(gather stats) the tables. So we can not …

[Continue Reading...]

A Simple PL/SQL Block

Admin August 10, 2019 PL/SQL TUTORIAL

Each PL/SQL program consists of SQL and PL/SQL statements which from a PL/SQL block. PL/SQL Block consists of three sections: The Declaration section (optional). The Execution section (mandatory). The …

[Continue Reading...]

Advantages of PL/SQL

Admin August 9, 2019 PL/SQL TUTORIAL

Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or logical module. PL/SQL Blocks …

[Continue Reading...]

Category: PL/SQL TUTORIAL