Home
News
Products
Scripts
Downloads
Registration
Links
Contact
Forum
 
 
Script Description Update
CompTrig This procedure compiles all triggers in the specified schema.  This process only takes place in the server and therefore is usually is much faster  then other spooling based scripts. 27-JUN-2002
GenSynos This procedure generates public synonyms for all objects in the given schema. This process only takes place in the server and therefore is usually is much faster  then other spooling based scripts. 27-JUN-2002
GenGrants This procedure generates public synonyms for all objects in the given schema. This process only takes place in the server and therefore is usually is much faster  then other spooling based scripts. 27-JUN-2002
GenUsers This procedure generates a spool file named "CreateUsers.SQL" that allows to regenerate all the existing users in the current schema.  The interesting in this script is that this script uses a undocumented Oracle feature to automatically regenerating the existing passwords of the users. 27-JUN-2002

 

CompileAllObjects This procedure compiles all invalid objects in a given schema or a complete database and is an alternative to the build-in dbms_utility.compile_schema proceduere. 22-FEB-2004

 

CheckPassword This function allows to check if a user/password combination is valid on a given server. This is usually not possible from within PL/SQL and Oracle does not offer any build-in mechanism or workaround to do so. 22-FEB-2004

 

NumberToWords This package provides a function NumberToWords converting numbers to their English equivalent and returns it as a string. 03-MAR-2004

 


Send web page comments to info@materialdreams.com. Last updated Thursday January 29, 2004 23:37:04 +0100 .
Copyright 1998-2005 Material Dreams. All Rights Reserved