oracle

Oracle database and SQL

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.

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

1 answer• 1 view

01/19/2026, 10:12 AM

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.

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

1 answer• 1 view

01/17/2026, 04:24 PM