OraTechInfo.co.uk
for Oracle Developers and DBAs
SQL Tuning
- SQL Tracing - Obtaining the execution path / trace file
- Cardinality - Influencing estimated cardinality
- Scalar Subquery Caching
SQL/XML
- SQL/XML and XPath - Mechanisms for efficiently generating and processing XML from SQL
- XMLTYPE - Utilising XMLTYPE for XML Storage
Security
- FGAC - Using Fine-Grained Access Control
- SQL Injection - Understanding this database exploit
PL/SQL
- PL/SQL Compiler Flags
- Message Queueing
- Triggers - Using database triggers effectively
- Lists to Collections - Converting from one to the other
- Object Relational - The OR features of Oracle RDBMS
General Information
- Using Views - Why database views are the best thing since sliced bread
- Scalar Subqueries - How to utilise this useful feature...
- Deadlocks - Getting ORA-00060? Then look here...
- ANSI JOIN Syntax
- Using NULLs - How much do you understand about NULL?
- OLAP and Analytics - Using Analytic Functions in SQL
Links
- OraTechInfo.co.uk blog
- Ask Tom
- Tanel Poder's blog
- Oracle Scratchpad
- Oracle Technology Network (OTN)
- Oracle University
- Oracle REST Data Services (ORDS)
- OTN Developer VMs
- Oracle VirtualBox
- Oracle-Base.com
- Oracle 12c Documentation
- Oracle Blogs
- JSON in the Oracle Database
- Oracle Application Express (APEX)
- Oracle Linux OS and Support
- Oracle Support
- Oracle Software Downloads
