Source Management and Debugging

PL/SQL Engine The  PL/SQL engine  is the system that compiles and runs PL/SQL…

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

C

Common Table Expressions: The WITH Clause

Correlated Subqueries

Database Normalization

Set Operations in Oracle

Table Joins

Deleting a Parent Row

Building ERDs with Oracle SQL Developer

Creating Constraints

In the context of a relational database, a constraint is a rule that enforces …

Pivoting and Unpivoting Data with Oracle SQL

Using Aggregate Functions, GROUP BY, and HAVING in SQL