Utilities load/unload flat files and others.

In article j0_at_tcsi.tcs.com, madhu_at_tcs.com (Madhu Gopinathan) writes:
>
>--
>
>Hi,
>
> How to write the rows retrieved in a SELECT statement
>to a file(in a PROC program)? (similar to UNLOAD in Informix)
> How to reload a table from a file? (similar to LOAD or dbload in INFORMIX)
>
>
>Thanks,
>Madhu

I have some utilities written to do this. They are available via anon. ftp. The README file follows:

                        MISCELLANEOUS ORACLE UTITILES The utilities in this directory are a collection of tools I use to help me with Oracle.

Please note that some of these utilities are "quick and dirty", while others (noteably the ones written in Perl) are a bit more robust. I offer them only to share what I have written for my own use and do not make any guarantees that they will work for you. I hope they do help, of course, and if you find any bugs I'd appreciate a message. If you find them useful (or awful) I would like to hear your opinions.

Jeff

Location:

	host:	ftp.ml.csiro.au
	IP:	192.67.12.100
	dir:	/pub/jstander/oracle_utilities

In the above directory the following utilities for ORACLE and ORACLE*FORMS are stored as various zip, shar, and tar file archives:

	orautils.shar		- all utilities in shar format
	orautils.shar.Z		- all utilities in shar format, compressed
	orautils.tar.Z		- all utilities tar format
	orautils.zip		- all utilities zipped
	unloadr.Z   		- unloadr utility compressed
	unloadr.zip 		- unloadr utility zipped
	flatutils.shar		- shar file for ASCII data file utilities only

General:
	README                  - this notice
	oraperl.FAQ		- FAQ for oraperl

ASCII data file maintenance:
	add_delims		- insert or change delimiters in ASCII file
	add_delims.1    	- manual page for above
	insert_delims   	- insert delimiters at fixed columns in ASCII file
	insert_delims.1 	- manual page for above
	zerofill_fields 	- pad numeric/fill numeric/move fields in ASCII file
	zerofill_fields.1 	- manual page for above

FORMS 3.0 utilities
	checkform       	- variable reference info from .inp file
	compfldnames		- check field names against table in .inp file
	lineup                  - filter to reset field alignment in .inp file

Loading and unloading
	revline   		- write standard source code headers
	dexalign        	- field descriptor alignment in .dex file
	mkloadf			- create control, create table, and input files 
				  for Oracle data loading
	mkloadf.1       	- manual page for above
	revline			- create boilerplate headers for scripts/programs/dex files 
	revline.1 		- manual page for above
	unloadr			- extract data from Oracle table to delimited ASCII file, has
				  embedded man page

Database Maintenance
	create_index		- create table indexes
	drop_index		- drop table indexes
	nextval			- show next value in Oracle sequence

Perl/Oraperl subroutines:
	keypress.pl		- user input subs
	fullpath.pl		- find full path name of argument
	nsu.pl			- handle netgroup superuser access 
	rform.pl		- run Oracle forms in xterm window
	selection.pl		- create user selection menu 
	sqlx.pl			- SQL*PLUS subroutine library for perl & oraperl
	test_for_oracle.pl	- test if Oracle running on this host
	dtime.pl		- formatted time 
	misc.pl			- miscellaneous subs
	oraenv.pl		- set Oracle environment (needs customizing)
	oraenv6.pl		- set Oracle environment (needs customizing)
	revline.pl		- create standard source code headers
	rform.pl		- run a form with runform30
	subopts.pl		- parse options to Perl subs
	unloadr.pl		- support for unloadr

___________________________________________________________________________

Jeff.Stander_at_ml.csiro.au        _--_|\        Database Analyst
CSIRO Division Of Fisheries    /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart           \_.--._/       Tasmania 7001, Australia
Aus Tel: 002-325-332                 v        Intl Tel: +61-02-325-332
Aus Fax: 002-325-000                          Intl Fax: +61-02-325-000
___________________________________________________________________________