Easily Compare Schemas
Using an MD5 checksum, this solution checks the objects belonging to the schema. The checksum can then be compared with other schemas to ensure consistency. Ideal for comparing development, test and production schemas
Author: HunBug
Last Updated: 01 Jan 2006
Easily Display All PLSQL Errors for a Schema
A useful routine which displays all plsql errors for a schema. This little function is ideal for running after delivering updated to program units
Author: HunBug
Last Updated: 01 Jan 2006
Kill Idle Sessions
A plsql database function that will allow you to kill a session that has been idle for longer than a specified period of time
Author: HunBug
Last Updated: 01 Mar 2008
Oracle Database Cold Backup and Restore Scripts
Windows server command script for cold database backups. Use the dynamically created restore script for restoring each backup
Author: HunBug
Last Updated: 01 Sep 2007
Quickly Compile an Entire Schema
Useful function to compile all the objects for a schema. Ideal for running after making changes to a plsql or Java program units
Author: HunBug
Last Updated: 01 Jan 2006
Using DBMS_METADATA to Output Schema Source
This procedure uses DBMS_METADATA to build a script of create statements for objects that exist in a current schema.
Author: HunBug
Last Updated: 01 Oct 2006
Week Days Function
This function takes a 7 character string, each character representing a day of the week, Y for included, N for not included and returns a string of the included days of the week in a readable format
Author: HunBug
Last Updated: 01 Jun 2008
Which Code Called This Procedure?
A procedure, that can be added to existing code, which uses the call stack to determine the calling PLSQL object
Author: HunBug
Last Updated: 01 Oct 2006
Write a CLOB to a File
How to output data from a CLOB column, to a file on the server using the UTL_FILE built-in package
Author: HunBug
Last Updated: 01 Jan 2006
HunBug Store








Comments are all individually read, none are automatically posted to the site.