Used to modify data (e.g., INSERT , UPDATE , DELETE ).
To master Oracle SQL, you must understand how data is organized and how commands are categorized: Used to modify data (e
Used to define database structures (e.g., CREATE , ALTER , DROP ). Each row is uniquely identified by a Primary Key
Data is stored in Tables consisting of rows (records) and columns (attributes). Each row is uniquely identified by a Primary Key . SQL Command Categories: provides the bedrock for interacting with the Oracle
Used to retrieve data (e.g., SELECT ).
Manages changes made by DML (e.g., COMMIT , ROLLBACK ).
provides the bedrock for interacting with the Oracle Database, an object-relational database management system (RDBMS) produced by Oracle Corporation. SQL (Structured Query Language) is the set-based, declarative language used to query, manage, and protect data stored in these databases. 1. Key Concepts (Основни понятия)
