Dominik Grabińskidgrabinski.hashnode.dev·Feb 12, 2025Part 2: Good and bad practices at APEX! DevelopmentPart 1: analysis Part 2: development Part 3: release to production and beyond APEX Developer = Full stack developer An APEX developer often acts as a full-stack developer, managing the entire lifecycle of an application - from analysis to production...31 readsOracle
Huy Nguyenhuyandres2001.hashnode.dev·Feb 11, 2025Đánh index đừng chỉ dựa vào điều kiện WHERE!!!Trước đây, tôi hay lầm tưởng rằng, khi đánh index thì cứ nhìn vào điều kiện trong WHERE mà triển, nhưng tôi đã lầm, vẫn có những yếu tố khác ngoài điều kiện WHERE có ảnh hưởng đến việc sử dụng các giải thuật quét index, mà dùng giải thuật khác thì ch...1 like·786 readsDev quèn học tối ưu DBOracle
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Feb 10, 2025Find an APEX Component ID in all Oracle APEX Dictionary ViewsOK Pretty niche, but if you ever want to find which columns in which views an APEX Component ID resides in, here’s a brute force approach for you: DECLARE l_id NUMBER := 7128208610686091; -- Change to your component ID l_sql VARCHAR2(4000); ...3 likes·133 readsorclapex
Cristhian Cano Bogadoparaguayandev.hashnode.dev·Feb 9, 2025Manejo de Errores y Mejora de UX en Oracle APEX con apex.eventIntroducción Una buena experiencia de usuario (UX) no solo mejora la usabilidad de una aplicación, sino que también previene errores y reduce frustraciones. En Oracle APEX, la API apex.event nos permite gestionar eventos de manera eficiente para evit...33 readsApex
Facundo Ezequiel Grandedbadetrinchera.com·Feb 7, 2025Cómo comprimir índices y... que sea sustentable en el tiempoEl parámetro DB_INDEX_COMPRESSION_INHERITANCE con sus posibles valores (TABLESPACE | TABLE | ALL | NONE) indica si el índice debe heredar la compresión del tablespace, de la tabla o de ningún lugar. Por omisión el valor es NONE, por ende no hereda lo...Oracle
David Sanzdbaenlasombra.com·Feb 6, 2025[OGG] OGG-01431 OGG-01151 OGG-01296 Error mapping from {0} to {1}Mientras configuraba GoldenGate recientemente para sincronizar dos entornos hasta el día del cutover, me encontré con el siguiente error: 2025-02-04 15:49:09 WARNING OGG-01431 Aborted grouped transaction on XXXX.XXXX.XXX, Mapping error. 2025-02-04 ...2 likes·42 readsOCIreplicat
Gerlyn Mgetintokube.com·Feb 5, 2025How to Migrate an RDS Database to Another AWS Account💡Migrating an Amazon RDS (Relational Database Service) instance from one AWS account to another is a bit different from migrating an EC2 instance. Unlike EC2, RDS is a managed service, and you can't directly "Create AMI and give permission to destinat...11 likes·38 readsHow to - AWSrds-migration
Facundo Ezequiel Grandedbadetrinchera.com·Feb 5, 2025Como migrar una base on-premise a AWS (RDS oracle) mediante un export/importRealizar un export de la base on-premise. El o los archivos resultantes (dmp) subirlos al storage S3 de amazon. Esto se puede realizar desde la consola de AWS. Transferir el o los archivos dmps hacia el servidor de base de datos utilizando el proce...migracion
Dominik Grabińskidgrabinski.hashnode.dev·Feb 5, 2025Part 1: Good and bad practices at APEX! Analysis and PoCPart 1: analysis Part 2: development Part 3: release to production and beyond First things first: Analysis Is APEX suitable? Is Oracle APEX a Good Choice? When deciding on a platform, it’s essential to evaluate if Oracle APEX fits your application’s...85 readsOracle
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Feb 3, 2025Using AI to generate Oracle APEX Theme Roller Styles v.2I’ve previously blogged on this subject, however I found that as new versions of the Universal Theme appeared, it meant that that approach no longer worked. Here is an approach that is hopefully future proof. It works on APEX 24.2 at least. NOTE: I a...2 likes·505 readsorclapex