• About Me
  • Contact
  • Linux
  • Oracle
Wadhah DAOUEHI
Wadhah DAOUEHI
Oracle and Linux blog
LinkedIn YouTube Twitter
  Menu
Skip to content
  • About Me
  • Contact
  • Linux
  • Oracle
LinkedIn YouTube Twitter
LinkedIn YouTube Twitter

Category Archives: 23ai

23ai: Create table if not exists

By Wadhah DAOUEHI | May 30, 2024 - 3:51 pm |May 30, 2024 23ai
Leave a comment

Within 23ai, we can create a table if not exist and we can ignore the … Read More →

23ai: Direct join with DELETE

By Wadhah DAOUEHI | May 30, 2024 - 1:54 pm |May 30, 2024 23ai, Oracle 19c
Leave a comment

As new features within the 23ai Oracle database, we can use the join in the … Read More →

23ai: Direct join with UPDATE

By Wadhah DAOUEHI | May 30, 2024 - 1:47 pm |May 30, 2024 23ai
Leave a comment

As new features within the 23ai Oracle database, we can use the join in the … Read More →

23ai: Having with alias

By Wadhah DAOUEHI | May 27, 2024 - 3:14 pm |May 30, 2024 23ai
Leave a comment

Within the Oracle database 23ai, we can use an alias in the HAVING clause, With … Read More →

Create FREE 23ai Database

By Wadhah DAOUEHI | May 26, 2024 - 10:37 pm |May 26, 2024 23ai
Leave a comment

After installation of the Oracle database 23ai RPM, we are going to create the FREE … Read More →

Oracle Database 23ai installation RPM

By Wadhah DAOUEHI | May 26, 2024 - 1:02 pm |May 26, 2024 23ai
1 Comment

My first installation of the new version of Oracle Database 23ai, for more details: oracle-23ai-now-generally-available … Read More →

23c: Database has been previously opened and closed

By Wadhah DAOUEHI | February 12, 2024 - 2:52 pm |May 30, 2024 23ai, Oracle 19c
Leave a comment

While the database is OPEN, we can close the database to the MOUNT status, and … Read More →

  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Oracle 19c: Index-Organized Table (IOT)
    • Oracle 19c – SQL Access Path: Index Skip Scan
    • Oracle 19c – SQL Access Path: Index Full Scan
    • Oracle 19c – SQL Access Path: Index Range Scan
    • Oracle 19c – SQL Access Path: Index Unique Scan
    • 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)
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter