How Can I (...) ?
 
Home

Resources
Library
How Can I?
Code Samples
Presentations
Links
Book Reviews
Downloads
User Groups
Humor


General
Contact
About
Services
Legal Notice & Terms of Use
Privacy Statement
A Guide To Meeting Challenges in Oracle Database 11gR2 Modified
1 Guarantee case insensitive uniqueness Click Here 28-Oct-2009
2 Read a list of operating system files into a PL/SQL array (without using C or Java) Click Here 28-Oct-2009
3 Identify the columns and data types in a weakly typed ref cursor Click Here 12-Feb-2012
4 Write a CLOB to a file Click Here 29-Nov-2010
5 Track the parts of my application that are in use Click Here 02-Nov-2009
6 Create a data type that will only hold the values 0 and 1 Click Here 21-Nov-2009
7 Create a single check constraint across multiple columns guaranteeing only one is used Click Here 16-Nov-2009
8 Trap, in a table trigger, the name of the column being updated Click Here 19-Nov-2009
9 Only report the rows from a query if the number of rows exceeds a limiting value Click Here 20-Nov-2009
10 Work effectively with the deprecated LONG data type Click Here 11-Jan-2010
11 Write block corruption alerts to my alert log Click Here 02-Feb-2010
12 Control services and scheduled jobs at startup Click Here 29-Jun-2010
13 Add a NOT NULL column to an existing table Click Here 05-Jul-2010
14 Perform string aggregation Click Here 04-Aug-2010
15 Find the mode of a set of values from a table Click Here 16-May-2011
16 Optimize collection of optimizer statistics Click Here 01-Nov-2011
17 Utility Library Click Here 01-Nov-2011
18 Secure credit cards in my application Click Here 01-Sep-2011
19 Export a comma or vertical bar delimited file Click Here 02-Sep-2011
20 Metrics Library Click Here 01-Nov-2011
21 Run multiple functions and/or procedures in parallel Click Here 31-Dec-2011
22 Determine the headroom between my current SCN and the maximum allowed SCN Click Here 10-Jan-2012
23 Extend Fine Grained Auditing to Only Audit Specific Database Users Click Here 12-Jan-2012
24 Create and use a schema password no-one knows? Click Here 24-Feb-2012
25 Load a table with relative days, weeks, and months Click Here 05-Mar-2012
26 Perform Secure Password Assignment Compliant with SOX and HIPAA Click Here 21-May-2012
27 "Real" Transparent Data Encryption Click Here 14-Mar-2013
28 Find Segments Wholly Located Above DataFile Corruption Click Here 27-May-2013
       
This is the start of a new Morgan's Library feature.
For the next couple of years, while we learn more about 11gR2,
we will be focusing our efforts here.
Please join us while we grow this section
and learn how to index it so you can find what you need.
Can we code it?

Yes we can!
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved