#!/bin/sh

#  example2-1.sh

#Generate 500 rows for a table called employees with 5 columns, commit after every
# 20 rows that are inserted, and also generate the create table script

#  First column called employee_number that is a unique number of maximum size 99999
#  Second column called employee_name of varchar2 of maximum length 30 that can vary in size
#  Third column called address of varchar2 of maximum length 40 that can vary in size with
#        a 20% percentage of NULLs and can also contain punctuation characters
#  Fourth column called postcode of number with the maximum length of 99999 that can vary in size
#  Fifth column called age of number with the maximum size 120 that can vary in size


employees=employees.sql

echo "redirecting output to $employees"

../../oragen --rows 500 --table-name employees --commit 20 --gen-table \
          --number --unique --length 99999 -C employee_number \
          --varchar2        --length 30    -C employee_name   \
          --varchar2 --length 40 --Null 20 --cangrow --punctual -C address \
          --number   --length 99999 --cangrow -C postcode \
          --number   --length 120   --cangrow -C age \
          > $employees