script help

Shell Programming and Scripting
1

Hi
I have a script with create tables ,I am callig same scripts several times,when first time call it will create first table ,when call second time it has to create 2nd table.Is it possible without creating multiple scripts with tables?.

ex:
a.sh

create table ab1(a1 number,...);
create table ab2(a2 number,..)

1st time
#sh a.sh
it has to create ab1
2nd time
it has to create ab2.

Thanks,
MR

2

Not sure if I understand completely but you can pass a parameter (e.g 'tablename') to a.sh and control the flow there.

Or, create a function inside of a.sh that will create the correct table based on what you passed to the function createTbl (), for example.