#

oracle

Oracle database technologies and products

ProgrammingHow to Execute Oracle Package Procedures via JDBC

Learn the correct way to execute Oracle package procedures via JDBC for DDL operations. Fix 'table doesn't exist' errors and ensure database changes persist.

3 answers• 4 views
DatabasesScalable 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.

4 answers• 4 views
DatabasesOracle 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.

1 answer• 2 views
ProgrammingPL/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.

1 answer• 7 views