Manages changes made by DML (e.g., COMMIT , ROLLBACK ).
To master Oracle SQL, you must understand how data is organized and how commands are categorized: Manages changes made by DML (e
Used to retrieve data (e.g., SELECT ).
Data is stored in Tables consisting of rows (records) and columns (attributes). Each row is uniquely identified by a Primary Key . SQL Command Categories: Each row is uniquely identified by a Primary Key
Used to define database structures (e.g., CREATE , ALTER , DROP ). declarative language used to query
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 (Основни понятия)
Controls access to data (e.g., GRANT , REVOKE ).