|Code Listing by Andy Archer|
This script solicits a table privilege and grantee user name at the SQL*Plus prompt, then builds and executes a file of GRANT statements to grant the privilege on all user tables to the grantee user.
This SQL*Plus script shows data on scheduled jobs, non-broken jobs, broken jobs, and jobs currently running under the DBMS_JOB package
These two SQL*Plus scripts run SQL to find all privileges and roles granted to a specified user or role. Each script spools its output to a file which is then opened in Notepad.
This PL/SQL stored procedure returns a person's age in whole years. It returns the number of whole years between two dates, and will also validate a date. Includes a stored function version.
All files and free downloads are copyright of their respective owners. We do not provide any hacked, cracked, illegal, pirated version of scripts, codes, components downloads. All files are downloaded from the publishers website, our file servers or download mirrors. Always Virus check files downloaded from the web specially zip, rar, exe, trial, full versions etc. Download links from rapidshare, depositfiles, megaupload etc not published.