Dont Panic!

TimeHole.com

Oracle utilities

PreviousPage NextPage

Updated: 12 Aug 13

Main

Projects/Customers

Contact Me

Software

Personal

Page of Software
Databases & Linux

Free Script and utilities

Table API generator

Data Unload

Grants,Synonyms,Sequences

PHP Utils

Old SQL guide

Old PL/SQL guide

A Jersey Linux User Group?

Free Utilities / Useful Scripts.

Here are some SqlPlus-scripts that everybody that is working with an Oracle databases writes over and over again. More or less sophisticated. I wrote my first ones years ago and I end up writing the same scripts in project after project. I put this on the web because I failed to find a script when I was searching for one myself. I hope this will help someone in that same situation.

There are two scripts used to create SYNONYMS and GRANTS. These are used in every Oracle project and are rewritten over and over again during development. Why not automate it from start?
The drop and create SEQUENCES can be used to reset/restore sequences quickly in a test system.
The UNLOAD script are handy to use even if it does not cover all data types and formats.
The PL/SQL PACKAGE GENERATION script is useful to get a standard package that contains a lot of trivial base-code, as a template, before you start coding and create code that really does something useful in your applications.

These scripts are not unique in any way. Developers around the world has written versions of these for years. You may use my versions freely, as is, or modified. This code is released under and within the GNU Public License. If you use my scripts, please leave my reference in it. If you like to add functionality and/or corrections, feel free to mail me suggestions.
To "download" the file, click on the "Show Script" button and save the page, and change the name to the "suggested name.sql".



API generator PL/SQL package for table(s).
Data unload/load function.
Create Synonyms, Grants and Sequences scripts.

>> Page 2

Code is released under the terms of the GNU General Public License as published by the Free Software Foundation.




I work with databases

images/ora_logo.gif
images/mysql_100x52.gif


And OpenSource Sw

images/phpclasses.gif


I use fedora linux

try it or try

Ubuntu or PcLinuxOs


Share information and knowledge!

images/180px-Green_and_white_machine.jpg

I'm based in Jersey, Available for assignments in all of Europe, On-Site or Remote. Call or mail me!

Jersey Linux User Group

Jersey Linux User Group

Page: th_orautl Date:Wed Sep 3 0:40:22 BST 2014

Copyright©2003-2013 Timehole.com All Rights Reserved.

Updated: Mon, 12 Aug 2013 16:19:27 +0100 Load time:0.01s