Pin to Start Menu Hack
social.technet.microsoft.com/Forums/en-US/dd2b13ef-2968-4f23-b531-57d1e9d634e3 Enable file extensions (if required). Open a new File Explorer window and navigate to the directory of your .vbs file. R
Planet of the APEX
A blog about all things Oracle APEX with some PL/SQL and Javascript thrown in!
Latest articles
Oracle APEX download csv example
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...
Subqueries
When to Use
Self-Joins
When to Use
Window Functions
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 ...
Common Table Expressions (CTEs)
When to Use
SQL Query Optimization Techniques
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...
Tutorial Sites
Handy links
Oracle APEX DB Object Dependencies
APEX v23.2