No description, website, or topics provided.
Python PLSQL
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
doc Added documentation for remaining tools. Sep 8, 2010
sql Move SQL files to subdirectory; ignore any created .egg-info files. May 7, 2009
.gitignore Development has moved to GitHub. Aug 23, 2017
.hgeol Use native line endings in working copy and Unix line endings in repo… Jul 12, 2014
CopyData.py The attribute maxlength has been replaced with bufferSize. Aug 23, 2017
DbDebugger.py With the new textwrap in place, the description of the application ca… Jun 3, 2010
DescribeObject.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
DescribeSchema.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
DumpCSV.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
DumpData.py Migrate to using Python 3. Jul 12, 2014
Exceptions.py Set native line endings on all Python source files. Sep 5, 2010
ExportColumn.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
ExportData.py Replace file() with open() -- which is the proper method to use in an… Aug 26, 2015
ExportObjects.py Added support for performing flashback queries when describing objects. Sep 5, 2010
ExportXML.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
GeneratePatch.py Migrate to using Python 3. Jul 12, 2014
GenerateView.py Migrate to using Python 3. Jul 12, 2014
HISTORY.txt Make use of the builtin module csv and the standard option --schema; in Sep 8, 2010
ImportColumn.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
ImportData.py With the new textwrap in place, the description of the application ca… Jun 3, 2010
ImportXML.py Replace all file() with open() which is the proper method to use in a… Aug 27, 2015
LICENSE.txt Preparing to release version 8.0. Sep 5, 2010
MANIFEST.in Include the documentation directory in the source distribution. Sep 8, 2010
Options.py Added support for performing flashback queries when describing objects. Sep 5, 2010
PatchDB.py Set native line endings on all Python source files. Sep 5, 2010
README.md Further improvements to README.md. Aug 23, 2017
RebuildTable.py Migrate to using Python 3. Jul 12, 2014
RecompileSource.py With the new textwrap in place, the description of the application ca… Jun 3, 2010
release.py Added support for producing releases for each different Oracle version Sep 9, 2010
setup.py Use cx_Freeze 5 and update version to 9.0 (since it is now running un… Aug 17, 2015

README.md

cx_OracleTools

This project contains a number of Python scripts that handle Oracle databases. Each of these scripts is self documented by the --help or -h option. Additional documentation will be forthcoming at a later date. A brief description of each script is provided here.

  • CopyData - copy data from one table or view to another
  • DbDebugger - allows simple debugging of PL/SQL
  • DescribeObject - describe objects as SQL statements for recreation
  • DescribeSchema - describe multiple objects as SQL statements for recreation
  • DumpCSV - dump the results of a select statement as comma separated values
  • DumpData - dump the results of a select statement as insert statements
  • ExportColumn - dump the data from a column into a file
  • ExportData - dump the data from a database into a portable dump file
  • ExportObjects - describe object as SQL statements for recreation in files
  • ExportXML - export data from a table into a simple XML file
  • GeneratePatch - generate SQL script to go from one set of objects to another
  • GenerateView - generate a view statement for a table
  • ImportColumn - import the contents of a file into a column in the database
  • ImportData - import the data dumped with ExportData
  • ImportXML - import data from an XML file (such as those created by ExportXML)
  • PatchDB - execute statements in files, checking for errors
  • RebuildTable - generate SQL script to rebuild the table
  • RecompileSource - recompile all invalid objects in the database

This project depends on the following projects if used in source mode. If you are using the binary version these dependencies can be safely ignored.

The binary versions of these tools were built with cx_Freeze.

This project is released under a free software license. See LICENSE.txt for more details.