haczek.blog - Blog o cyfrowej transformacji, automatyzacji i AI

Executing SQL and PL/SQL as a logged-in user in Oracle APEX

Executing SQL and PL/SQL as a logged-in user in Oracle APEX

In Oracle APEX, you may want to execute SQL queries and procedures as the logged-in user instead of the default parsing user (once APEX_PUBLIC_USER, now ORDS_PLSQL_GATEWAY). This approach allows you to leverage the database permissions associated with the logged-in user, which is particularly useful when working

How to configure Active Directory authentication in Oracle APEX

How to configure Active Directory authentication in Oracle APEX

Oracle Application Express (APEX) is a powerful, web-based application development platform that allows developers to build scalable and secure applications with minimal coding. One of the key aspects of any application is authentication, and integrating Active Directory (AD) for authentication can provide a seamless and secure login experience for users.

Horizontal scroll bar on top of Interactive Grid in Oracle APEX

Horizontal scroll bar on top of Interactive Grid in Oracle APEX

The default Interactive Grid in Oracle APEX includes a horizontal scroll bar at the bottom. While this is useful, it requires users to scroll down to the bottom of the grid to move horizontally, which can be inconvenient, especially with large datasets. Adding a horizontal scroll bar at the top

Anchoring header in APEX's Classic Report

Anchoring header in APEX's Classic Report

Navigating vast tables can be daunting, but there's a trick to keep your headers anchored at the top. While this is a breeze in Interactive Reports and Grids, Classic Report regions and custom HTML tables require a workaround. Enter APEX's JavaScript arsenal: the Sticky Table Header

How to connect to Oracle Autonomous Database using DataGrip or SQL Developer

How to connect to Oracle Autonomous Database using DataGrip or SQL Developer

Connecting to a Autonomous Database is not as simple as one might think, but you probably already know that since you're here. First, get the connection string or wallet First, log in to the Oracle cloud, navigate to the database and click the "Database Connection" button.

Multiple databases on a single ORDS

Multiple databases on a single ORDS

APEX does not function without ORDS, and sometimes we want to connect two or more database instances, or APEX instances such as DEV, TEST and PROD, to a single ORDS server. To do that we need to issue 2 commands, just remember that you need to issue these commands while

How to create new users and grant them permissions in the Oracle Autonomous Database?

Oracle Database

How to create new users and grant them permissions in the Oracle Autonomous Database?

Managing user roles in Autonomous Database differs slightly from what we encounter in a traditional Oracle on-premise database. It's worth noting at the outset that we don't have access to SYSTEM and SYS users. When we create a database, we only get access to the ADMIN

O co chodzi z tym AI?

Sztuczna inteligencja

O co chodzi z tym AI?

AI weszło na światowy rynek IT z mocnym przytupem pod koniec listopada 2022 roku, gdy zadebiutował ChatGPT. Chociaż wcześniej dostępne były narzędzia takie jak GPT-3, Midjourney oraz Stable Diffusion, to właśnie premiera ChatGPT zainicjowała prawdziwą rewolucję, która przetoczyła się przez branżę, nie pozostawiając nikogo obojętnym. W rozmowach z moimi kolegami