GitHub

Backup all tables from an oracle database to .xlsx-files in a local folder

Backup all tables from an oracle database to .xlsx-files in a local folder. This tool can be usefull if you want to do a local backup from all tables of a database or you just want to have all tables ...
GitHub

sqlplus.vim : Execute SQL queries and commands from within VIM (using Oracle's SQL*Plus)

#description This file contains routines that may be used to execute SQL queries and describe tables from within VIM. It depends on SQL*Plus. You must have $ORACLE ...
Houston Chronicle

How to Reindex SQL Tables

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...
ZDNet

Store SQL*Plus variables

Oracle SQL*Plus has a very useful subparameter to the column parameter called NEW_VALUE. The NEW_VALUE directive allows you to store data retrieved from an Oracle table as a variable inside the ...
Linux Journal

SQLite Extraction of Oracle Tables Tools, Methods and Pitfalls

The SQLite database is a wildly successful and ubiquitous software package that is mostly unknown to the larger IT community. Designed and coded by Dr. Richard Hipp, the third major revision of SQLite ...
IEEE

Managing reference tables using Oracle Dynamic SQL and metadata

Abstract: Reference tables are designed to support applications using a relational database management system like Oracle or Sybase. The information in these tables changes over the time. Although a ...