oracle

Oracle database migration and CDC configuration

Databases Scalable CDC Architecture for Oracle Data Lake with AWS DMS

Learn how to implement a scalable CDC architecture using AWS DMS to migrate Oracle data to a Medallion data lake with Apache Iceberg on S3 and AWS Glue processing.

#aws
#cdc
#databases
#data-lake
#devops
#iceberg
#oracle

4 answers• 2 views

04/03/2026, 06:51 PM

Programming PL/SQL Session State for HTML Forms with HTP & DBMS_SESSION

Elegant PL/SQL solution using Oracle session contexts and DBMS_SESSION for multi-step HTML web forms with HTP. Reduce parameter passing, modularize code, handle arrays in mod_plsql apps for scalable state management.

#dbms-session
#html-forms
#htp
#oracle
#plsql
#session-management

1 answer• 3 views

01/17/2026, 04:24 PM

Databases Oracle SQL: Get Max Date Row Per UserId (Latest Record)

Learn Oracle SQL techniques to fetch rows with maximum Date per UserId. Use ROW_NUMBER window function, JOIN subquery, NOT EXISTS, or KEEP DENSE_RANK for latest records efficiently on large tables.

#databases
#group-by
#oracle
#sql
#window-functions

1 answer• 1 view

01/19/2026, 10:12 AM