| My
Availability: |
|
|
|
| 14th June 2008 -
I am now supplying Oracle
consultancy services to UBS. I am available for adhoc work; would you like to hire me? Check out
my CV and
drop me a line |
|
| |
|
|
|
| |
|
|
|
| New and
Updated Utility Packages |
|
Code Tips and Undocumented Oracle Nuggets |
|
| |
|
|
|
- 30th April 2008
A new package exposing an API
to describe a ref cursor using PL/SQL -
XUTL_REFCURSOR
- 15th January 2007
Now introducing
XUTL_FINDFILES -
list files in directories with pure PL/SQL (10g only)
- 11th December 2006
Version 14 of
XUTL_FTP is
now available for
download. This includes a number of bug fixes and has
proven compatibility with MS IIS FTP. This release also
includes a new 10g specific version!
- 25th April 2006
A new statspack administration
package for DBA's which you can get
here
A new package that implements FTP from PL/SQL is now available. This API will transform your data loading operations – get XUTL_FTP here
- 3rd April 2006
At long last, the Power version of XUTL_NET is available! Now with nbtstat functionality, check out the ability to perform a NetBIOS name table status query from PL/SQL
here
|
|
- 02nd May 2008
Use Datapump to quickly create
a user as a clone without writing to an export file with this new
tip
- 31st May 2007
Create a view to extract Job
queue errors from the alert log with this new
tip
- 29th May 2007
An update to an old tip:
list directory
contents with PL/SQL
- 8th January 2007
Determine server side
environmental values with this PL/SQL
tip that
documents more of the undocumented world of Oracle
- 9th October 2005
Emulate 10g functionality in 9i
and 8i with this DBA
tip that
ensures database archiving
- 13th January 2005
Automatically backup a Last
Known Good version of your SPFILE after every successful
database startup with this DBA
tip
|
|
|
|
|
|
Download the latest Trial version of XUTL_NET, the Oracle database
PL/SQL API
for sending 'Net Send' messages:
- send net send messages
from PL/SQL!
- platform independence -
works on UNIX, LINUX and MS Windows platforms!
- easy to install - no
configuring of external procedures or loading extra java
classes!
Try for yourself NOW - download
a FREE trial version here!
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
| |
| |
