So when I read Why every blogger should create resource pages and saw some of examples from people such as thatjeffsmith, I thought I'd draft this up, over time update my older posts with references to related content and generally clean things up. I'll try to keep it up-to-date, too - but no promises. Maybe translate into contemporary menu, too.
I also post a lot about AUSOUG, science & other stuff, so this is a great way to trim the fat and cut right to the technical stuff.
I don't think it's complete - I'll try to keep it up to date and maybe pretty it up a little.
As a guide, those marked -- recent were added since the last time I last updated this page (Jan 2014).
APEX
APEX Feature RequestsDemo app - blog examples
Demo app - Consuming Plug-ins
Demo mobile app - User group conference
Useful APEX URLs
Modify APEX workspace login
APEX object synonyms
Chrome for APEX dev
SQL Injection
User Interface Detection
Reasons to upgrade APEX
LDAP Authentication
jQuery
jQuery error page replacement (3.x)Using jQuery selector in APEX
jQuery vs ApexLib
jQuery dialog boxes
jQuery Datepicker 3.x
Highlight cell background in report
APEX closing modal dialog on escape
Customise totals classic report
Modify Region title dynamically -- recent
APEX Maintenance
Upgrading to 4.2Upgrading to 4.1
Upgrading Glassfish
Managing APEX using APIs
APEX Administration
Reporting
Apex IR CSS tweaksAPEX Tree region use case
Middle tier
Considering Apex in the cloudApex listener issues
Glassfish URL not allowed
Glassfish isn't dead -- recent
Performance
APEX variables in SQLAPEX Conditions
Performance issues with v()
Bulk bind in Apex
Post calculation computations
Beginning APEX
APEX URL mnemonicAPEX 4.2 Show Grid
APEX 101 - dynamic actions
APEX 101 - set region on page load
Tutorial - using read only
Tutorial - basic record maintenance
APEX Forms
Using sequencesWorking with compound primary keys
Show/Hide APEX labels
Cascading LOV 4.0
Validate e-mail using PL/SQL
User friendly APEX date items
Build Options
Build options intoductionBuild option use case - experiments -- recent
Build option use case - replace condition never -- recent
Themes & Templates
Modifying Tab behaviourCSS pull down menu
Freezing pull down menu
Plug-ins
Spice up your APEX application -- recent
Community
APEX developer extensionAPEX 5 Desires
APEX 5.0 SOD
APEX 4.2 wishlist
APEX 4.2 SOD
APEX 4.1 SOD (statement of direction)
11g Documentation trick
Application Design
Consume selected Twitter accounts using RSS
Published Material
Oracle APEX Techniques - Video CourseAPEX Mobile Web Development review
APEX Best Practices book review
Expert Oracle APEX Plugins review
Expert Oracle APEX review
Agile Oracle APEX review
APEX 4.0 Cookbook book review
Forms Converter book review
OTN Forums upgrade review
Presenting
PreziThoughts
Steven Feuerstein Perth Review (Part 2)
PL/SQL
Quoting inside literal stringsConditional compilation
PRAGMA Autonomous transaction
Wrapping/Obfuscating PL/SQL
PRECEDES/FOLLOWS Trigger
Reset sequence values
SQL
SQL 101 - group by rollupRegular expressions 101
SQL Analytics 101 - Row number()
Analytical functions with PIVOT
Coalesce vs NVL
Short Circuit Evaluations
NULLIF
Full outer joins
Recursive subquery - hierarchical
Escape wildcard search
Building Test Scenarios
Date densification - Model clause
Searching view SQL (LONG datatype)
Finding stuff in ALL_VIEWS using XML
Using WITH (Subquery Factoring)
Intervals (Dates)
PIVOT
UNION ALL
12c new developer features
SQL Developer Preferences
1 comment:
Thanks for sharing such valuable information.
Post a comment