New features Oracle 26ai
This course is devoted to exploring what’s new, what’s different, and what truly matters in Oracle Database 26ai. You will learn how AI-enhanced capabilities transform database design, administration, development, and performance optimization—reducing manual effort and enabling smarter, faster decision-making.
Duration: 4 hours
Lanquage : Slovak
Development
SQL/PSQL enhancemet
- Table Values Constructor
- SELECT Without FROM Clause
- Aggregation over INTERVAL Datatypes
- Automatic PL/SQL to SQL Transpiler
- Boolean Data Type
- CEIL and FLOOR Support DATE, TIMESTAMP, and INTERVAL Data Types
- DEFAULT ON NULL FOR INSERT AND UPDATE
- Domains in Oracle Database 26ai
- DB_DEVELOPER_ROLE Role
- Schema Privileges
- MAX_COLUMNS
- Rename LOB Segments
- Development Focus – JSON Operations
- JSON_ARRAY Using Subqueries
- JSON_BEHAVIOR Parameter
- JSON Collections
- JSON_SERIALIZE
- JSON Schema
DBA & Mission-critical
- Bigfile Tablespace Defaults in Oracle Database 26ai
- Bigfile Tablespace Shrink in Oracle Database 26ai
- Smallfile Tablespace Shrink in Oracle Database
- PDB Users in Oracle Database 26ai
- Priority Transactions
- Lock-free reservation
- True Cache
- SQL Firewall
- Hybrid Read-Only Mode for PDBs in Oracle Database 63ai
AI Artificial Intelligence
- Theory of Vector
- Examples of Vector Searching
- Load model
- Generate model
- Statements
- Vector Indexing
- HNSW index
- Inverted File Flat Vector Index
