#oracle Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Oracle Database 23ai : Group By and Having using Column Aliases

Starting with Oracle Database 23ai, you can use column aliases directly in the GROUP BY and HAVING clauses. This functionality was not available in earlier versions of Oracle Database.Example in Oracl...

25.04.2025 0 Read More

Oracle 23ai on ARM [ Release 23.0.0.0.0 - Develop, Learn, and Run for Free ]

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } Oracle 23ai - the FREE edition As of date Oracle 23ai is not yet released for On Prem , however the FREE edition is available and is...

26.04.2025 0 Read More

Oracle Cloud HCM 25B Release: What's New?

Does your organization use Oracle HCM Cloud? If so, get ready Oracle’s 25B release is around the corner, with a planned go-live in April 2025. These quarterly updates are not just routine maintenan...

28.04.2025 0 Read More

Exportar Connections do SQL Developer Para a extensão do Vscode

Botão direito em Oracle Conexões -> Exportar conexõesEscolhe a pasta de destino e nome do arquivoEscolha uma senha qualquer para criptografarFinaliza.Na extensão do vs code Crie e Abra uma cone...

28.04.2025 0 Read More

Oracle Database 23ai : DBMS_SEARCH - pure SQL Sorcery | A promising alternative to global indexes.

{ Abhilash Kumar Bhattaram : Follow on LinkedIn } 23ai DBMS_SEARCH Before jumping into this new feature in 23ai , let us understand what Oracle Documentation says about DBMS_SEARCH ...

29.04.2025 0 Read More

Oracle 23ai — Read-Only User Feature

The Read-Only User is one of the new features introduced in Oracle Database version 23ai. This feature enables administrators to restrict users from making any data modifications, even if they have th...

02.05.2025 0 Read More

🚀 Oracle E-Business Suite R12.2: Adding and Removing Application Tier Nodes

🧩 Oracle E-Business Suite R12.2📌 Overview Oracle E-Business Suite (EBS) Release 12.2 introduces a dual file system architecture with online patching, enabling high availability, modular maintena...

02.05.2025 0 Read More

Annotations in Oracle Database 23ai

In Oracle Database versions prior to 23ai, the Comment functionality allowed users to add descriptive information for objects such as tables, table columns, materialized views, and views. However, thi...

03.05.2025 0 Read More