D
I ❤️ Oracle APEX
HTML web.dev/html
CSS web.dev/css
JavaScript javascript.info
Python realpython.com
SQL sqlbolt.com
SQL sqlzoo.net
DevOps devopscube.com
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
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...
Sep 16, 20251 min read
Subqueries
When to Use
May 14, 20251 min read
Self-Joins
When to Use
May 14, 20251 min read
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 ...
May 14, 20252 min read
Common Table Expressions (CTEs)
When to Use
May 14, 20251 min read