A blog about all things Oracle APEX with some PL/SQL and Javascript thrown in!
declare l_csv clob; l_line varchar2(4000); begin -- Add headers (Replace with your actual column names) l_line := '"COLUMN1","COLUMN2"'; l_csv := l_line || chr(10); -- Loop through data (Replace with your table or query) for rec in ( select COL...
When to Use
When to Use
Aggregate Functions (Used for calculations over a set of rows) SUM(): Calculates the sum of values over a window. AVG(): Calculates the average of values. MIN(): Finds the minimum value. MAX(): Finds the maximum value. COUNT(): Counts rows over ...
When to Use
Indexing Create indexes on columns frequently used in WHERE, JOIN and ORDER BY clauses for faster lookups. Avoid SELECT * Select only the necessary columns instead of using SELECT * to reduce the amount of data retrieved. Query Execution Plan Analysi...
Handy links
APEX v23.2
In this example, I'm setting two page items using the data attributes from a button and refreshing three regions in a drawer. The drawer is then opened using the Open Region dynamic action. The button has the following link attributes data-id="&APP_I...
