tables

Bronze_en

What is a VIEW in Oracle? Complete Explanation with Diagrams: Structure, Use Cases, and Creation Method

Views (VIEW) are essential objects in Oracle Database that allow you to simplify complex queries, manage security, and p...
2025.08.06
Bronze_enEnglishOracle Basics_enTables_enViews_en
Bronze_en

How Oracle Indexes Work and How to Create Them! A Complete Guide to Reading Execution Plans

When you feel that an Oracle SQL search is slow, the first measure you should consider is utilizing an "Oracle Index." B...
2025.08.05
Bronze_enEnglishIndexes_enOracle Basics_enTables_en
Data Types_en

Comprehensive Guide to Oracle Data Types: Numeric, Character, Date, and LOB Types Explained

When creating tables in Oracle Database, you must define what type of data each column will store. This is done by assig...
2025.08.04
Data Types_enEnglishOracle Basics_enTables_en
Bronze_en

A Complete Guide to Creating Tables in Oracle Database [CREATE TABLE Explained]

Creating tables is one of the most fundamental skills when working with Oracle Database.This article provides a thorough...
2025.07.30
Bronze_enEnglishOracle Basics_enTables_enTablespaces/Datafiles_en