Source Management and Debugging

Packages

Architecture of PL/SQL PL/SQL's architecture involves around the three ma…

PL/SQL Procedures and Functions

Exception Handling in PL/SQL

Cursor

뒤이어 오라클 데이터타입 중 레코드와 컬렉션을 배운다. 레코드와 컬렉션을 한마디로 정의하면 세트 형태의 오라클 데이터 타입이라 할 수 있다.…

PL/SQL Records

Many programming techniques use collection types such as arrays bags, lists, ne…

PL/SQL Records

A row is a collection of column information corresponding to a single record.

PL/SQL Cursors

SQL is a  set-based language,  which means it processes data collectively in ba…

Using SQL Queries in PL/SQL Blocks

Control Structures

Analytical Functions: Defining Custom Window Frames

ROWS BETWEEN n1  PRECEDING and n2  FOLLOWING Let's consider a table shown i…

Analytical Functions: Calculating Running Totals

Imagine a situation where you're managing a score keeping system for games.…

Analytical Functions: OVER and PARTITION BY

Oracle SQL functions can be categorized into three main types: scalar, aggregat…

Conditional Expressions in a SELECT Statement

In programming languages, conditional expressions refer to structures that crea…

Common Table Expressions: The WITH Clause

Correlated Subqueries

Subqueries typically have syntactical autonomy, meaning that they can be execut…