Source Management and Debugging

Packages

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 bat…

Using SQL Queries in PL/SQL Blocks

What makes PL/SQL so powerful for transaction processing is its seamless integr…

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…

Subquery Basics

What Are Subqueries? As its name implies, SQL, the Structured Query Language ,…