Oracle -> Links

Oracle Learning Library ...free online learning content. The content ranges from videos, tutorials, articles, demos, step-by-step instructions to accomplish a specific task to in-depth, self-paced interactive learning modules.
Inhaltsverzeichnis der deutschsprachigen APEX und PL/SQL Community: Tipps, Tricks und Best Practices Auf diesen Seiten finden Sie Informationen, Tipps und Tricks zur Anwendungsentwicklung mit Oracle Application Express, SQL und PL/SQL.
- Betriebssystem-Kommandos und Dateisystemzugriffe mit Application Express
PL/SQL Email Client API ...sending emails is no problem and frequently done from Oracle database installations. But there is no package which is able to retrieve messages from a mailbox on a server. The here provided package MAIL_CLIENT closes this gap.
Oracle Scratchpad - NVL2() ... it’s a nice little option if you want to create a function-based index that indexes only those rows where a column is null.
jrXml to PDF - a declarative, pure PL/SQL reporting engine I want to design my report in a graphical way, then transfer the resulting report-definition to the database, and then render the report using a PL/SQL-package to PDF.
SQL Model Clause: References and Recommendations This is just a short list of where I learned the most about the MODEL clause for my postings:

Database Independence Vs Database Dependence Being , Peoplesoft / Siebel are now "Oracle" Products . Is there any roadmap to make it DB dependent applications?

https://forums.oracle.com/forums/ann.jspa?annID=1535FAQ Quick link to specific topics
Tabibitosan grouping "loosely grouped" data
Shortest Path ... How to know the shortest path from a source to a destination?
Model Clause about using with Dijkstra algorithm
What's the best way to create and free temporaries for CLOB parameters? ... 2 temporaries will be created, but there will only be 1 freeTemporary. Could this lead to a memory leak?
PL/SQL 101 : Understanding Ref Cursors I thought I'd give a quick summary of the basics behind ref cursors with a view to giving a clearer understanding of them.
Calculation of Western Easter Sunday based on Carter's Method ... don't forget about Easter
Sql script not able to insert unicode data in table when i try to run the script using sqlplus it fails as it tries to open the file in normal 1252 mode and finds junk in it.

All things Oracle The aim of All Things Oracle is to provide a gateway to the wealth of information and material available for Oracle developers and DBAs.
DOAG.tv YouTube channel der DOAG

Execute current worksheet file via SQL*Plus It’s a great feature to execute SQL scripts in a controlled and fresh environment without the hassle of opening SQL*Plus, connecting to the database and executing your script manually. Sad but true, SQL Developer doesn’t offer such a feature out of the box.
Cross Connection Queries Join tables across different connections

Oracle Forms Community Here we will post tips, tricks, solutions and other wisdom to Oracle Forms users.
How to - Base a data block on a procedure How to Base a data block on a procedure using the Advanced Database options (ADo)

Links