|
Category :
SQL and PLSQL
Key Preserved
-
A little trick when dealing with updates and key preserved tables.
Anydata datatype
-
An example on how to use anydata datatype.
Bulk Data Loading
-
A few design tips on improving overall performance of bulk data loading
and processing.
Outer Join Issue
- An issue to be aware of when dealing with SQL statements with outer
joins.
Function and Object Types
- Returning objects with functions and using them within SELECT
statements.
Pipelined Functions
-
An example on the usage of pipelined functions.
Simple Tips and Techniques
- A few simple tips and
techniques with SQL and PLSQL code.
Fine Tune PLSQL
-
Finding bottlenecks within PLSQL code.
MAP method with objects
- How and Why to
use MAP method with objects.
Use of Context
- An example on the usage of SYS_CONTEXT feature.
Segment Drop
- Overcoming the issue of oracle not releasing temp segments when
objects are dropped.
Oracle Encryption
- An example encryption routine.
9i Coding Practices
- A few
changes to PLSQL coding practices that developers need to be aware of.
Quick Data Transfer
- The fastest method available to transfer data between databases.
Generate DDL
- A few examples on using DBMS_METADATA package available with 9i to
generate object DDLs.
Cursor Expressions in
9i
- An
example on the usage of the cursor expressions and the advantages of
using it.
Releasing unused memory
- Reclaim unused memory after performing operations requiring large
amounts of memory |
