A set of script to better deal with Oracle
Shell
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
rtype
.gitignore
LICENSE
README.md
missed-fk-indexes.sql
table2excel

README.md

oracle-meta

Alpha stage

A set of experimental script to deal with Oracle database and some new idea about meta programming.

RType

Python experimental new data system. See relative folder

Excel export

To generate an excel export try out table2excel scott/tiger@orcl emp dep myviewz | tr '\t' , >my.csv

Credits: Tom Kyte http://tkyte.blogspot.co.at/2009/10/httpasktomoraclecomtkyteflat.html

Unindexed Foreign Keys

In some situation an unindexed foreign key cause oracle to do a table lock. missed-fk-indexes.sql help you finding out such issues

Local variables:

mode:markdown

End: