Recent Notes
Displaying keyword search results 1 - 4
Created by Dr. Xi on January 07, 2010 23:40:28
Last update: February 09, 2010 03:24:35
This is a utility to generate SQL insert statements for Oracle for one table, or a set of tables. It doesn't cover all possibilities but should be good enough for most cases.
import java.io.*;
import java.sql.*;
import ...
To generate insert statements for multiple tables, simply put the table names in a file, one per line, and use the -f switch.
Created by Dr. Xi on January 07, 2010 23:56:00
Last update: January 07, 2010 23:56:00
This is a utility that generates a script to grant privileges for an existing schema for Oracle.
import java.io.*;
import java.sql.*;
pub...
Created by Dr. Xi on January 07, 2010 23:51:44
Last update: January 07, 2010 23:53:57
This is a utility to generate a "create synonym" script for Oracle for an existing schema.
import java.io.*;
import java.sql.*;
pub...
Created by Dr. Xi on January 07, 2010 23:47:36
Last update: January 07, 2010 23:47:36
This is a utility to generate a "create role" script for Oracle for an existing schema.
import java.io.*;
import java.sql.*;
pub...