This is an article about the Index. Hello! Database indexes are data structures used to quickly retrieve data from databases. Among them, B-Tree is one...

This article examines the concept and type of optimizer. Hello! The database optimizer is responsible for optimizing user-written queries in the database to establish the...

트리거에 대하여 알아본 글입니다. 안녕하세요! 트리거(Trigger)는 데이터베이스에서 특정 이벤트가 발생했을 때 자동으로 실행되는 코드입니다. 이를 통해 데이터베이스에서의 작업을 자동화하고 데이터의 일관성을 유지할 수 있습니다. 이제...

This article is about the storage module and PL/SQL. Hello! Storage modules and PL/SQL are powerful tools used to create and manage procedures in databases....

This article is about procedural SQL. Hello! Procedural SQL is a language that combines the characteristics of Structured Query Language (SQL) and programming languages. This...