Blog Reference Map

I often use my own blog as a reference for common tasks - that's part of the reason why I post things in the first place - and to share with the Oracle community.

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.

APEX

APEX Feature Requests
Demonstration APEX Mobile Application
Accordion Mobile Template
Useful APEX URLs

Modify APEX workspace login -- recent
APEX object synonyms
Chrome for APEX dev
SQL Injection
APEX closing modal dialog on escape
User Interface Detection
Reasons to upgrade APEX -- recent

jQuery

jQuery error page replacement (3.x)
Using jQuery selector in APEX
jQuery vs ApexLib
jQuery dialog boxes
jQuery Datepicker 3.x

Maintenance

Upgrading to 4.1
Upgrading Glassfish
Managing APEX using APIs

Migrating Interactive Reports
Export deleted applications
Automating Apex Backups from the DB

Apex e-mail
Modify Apex login page
Considering Apex in the cloud
Apex listener issues
Glassfish URL not allowed
Application builder timeout

Performance

Apex variables in SQL
Performance issues with v()
Bulk bind in Apex

APEX Tips

APEX URL mnemonic

Apex for Forms developers - Tree View
Viewing APEX session state


Column formatting

Apex IR CSS tweaks
Mail merge with BI Publisher

Tutorial - using read only
Tutorial - basic record maintenance
Add tooltips to APEX report
User friendly APEX date items -- recent

Validate e-mail using PL/SQL
APEX form better practice - sequences
Using sequences
Working with compound primary keys
Show/Hide APEX labels
Post calculation computations
Cascading LOV 4.0
APEX Tree region use case -- recent

APEX build options
Locked Pages

Modifying Tab behaviour
CSS pull down menu -- recent
Freezing pull down menu -- recent


Plug-ins



Community

APEX developer extension
APEX 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

APEX Mobile Web Development review -- recent
APEX Best Practices book review
Expert Oracle APEX Plugins review -- recent
Expert Oracle APEX review
Agile Oracle APEX review
APEX 4.0 Cookbook book review
Forms Converter book review

Presenting

Prezi
Thoughts
Steven Feuerstein Perth Review (Part 2)

PL/SQL

Quoting inside literal strings
Conditional compilation
PRAGMA Autonomous transaction
Wrapping/Obfuscating PL/SQL
PRECEDES/FOLLOWS Trigger
Reset sequence values -- recent

SQL

SQL Analytics 101 - Row number() -- recent
Full outer joins
Recursive subquery - hierarchical
Escape wildcard search
Coalesce vs NVL
Short Circuit Evaluations
Building Test Scenarios
Date densification - Model clause
NULLIF
Searching view SQL (LONG datatype)
Finding stuff in ALL_VIEWS using XML
Using WITH (Subquery Factoring)
Intervals (Dates)
PIVOT -- recent
UNION ALL

SQL Developer Preferences
Post a Comment
Subscribe to: Posts (Atom)