23ai: Direct join with DELETE
As new features within the 23ai Oracle database, we can use the join in the … Read More
Oracle ACE Pro
-
Oracle Certified Expert
-
Oracle Cloud Infrastructure
-
MySQL: Administrator Certified Professional
-
PostgreSQL: Certified Associate
-
-
Recent Posts
- Oracle 19c – SQL Access Path: ROWID Scan
- Oracle 19c – SQL Access Path: Full Table Scan
- OS_AUTHENT_PREFIX External Authentication in Oracle Database 19c
- Oracle 19c Flashback Technology (7/7): Data Archives
- Oracle 19c Flashback Technology (6/7): Flashback Database/PDB
- Oracle 19c Flashback Technology (5/7): TRANSACTION
- Oracle 19c Flashback Technology (4/7): Table
- Oracle 19c Flashback Technology (3/7): Drop Table
- Oracle 19c Flashback Technology (2/7): Versions Query
- Oracle 19c Flashback Technology (1/7): Query
- Recommended UNDO Tablespace Size in Oracle 19c Using the Undo Advisor (SQL Only)
- Understanding UNDO Configuration and RETENTION GUARANTEE in Oracle 19c
- Materialized View Log in Oracle 19c (ON COMMIT)
- Materialized View Log in Oracle 19c (ON DEMAND)
- Reinitializing the Same Password After Expiration in Oracle 19c
- Switching Session User in Oracle Database
- Monitoring the Oracle Fast Recovery Area (FRA)
- Database 19c Vault: OWNER/Manager privileges !
- Enabling the Database Vault (Initialisation parameters)
- [FATAL] [DBT-09352] Error in validating dbv_owner credentials.
- Oracle 19c: Convert Table to range partition online
- Oracle 19c: Automatic List-Partitioned Table (2/2)
- Oracle 19c: Automatic List-Partitioned Table (1/2)
- Oracle 19c: Interval Partitioning (2/2)
- Oracle 19c: Interval Partitioning (1/2)
- Oracle Database 19c: Shared Server mode
- SYS.DBMS_BACKUP_RESTORE & SYS.DBMS_RCVMAN RMAN
- Oracle 19c: pdb_storage_clause
- NGINST-64051: Invalid Central Inventory location “null”.
- 23ai: Create table if not exists
