PL/SQL TUTORIAL Archives - Wings Of Technology

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