#!/bin/sh
 
# example1-2.sh
 
# generate 1000 rows for a table called orders with 2 columns, 
#
#   first column of type number that can up to the size 9999999 that is unique, 
#   second of type varchar2 of length 5 
#   with the respective column names orderno and purchase

#     redirecting to file

#     redirect output to a file called orders.sql

../../oragen --rows 1000 --table-name orders --gen-table \
          --number   --length 9999999 --unique --column-name orderno \
          --varchar2 --length 5 -C purchase \
          > orders.sql

echo -e "to load data do\n\tsqlplus username @orders.sql\n"