script help

mohan705 · #1 (**permalink**) 04-23-2009

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

giannicello · #2 (**permalink**) 04-23-2009

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.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script	praka	Shell Programming and Scripting	6	04-15-2009 07:09 AM
need inputs on how i can change my script to reduce amount of time the script takes	madhul2002	Shell Programming and Scripting	1	04-01-2009 08:40 PM
create a shell script that calls another script and and an awk script	magikminox	Shell Programming and Scripting	0	06-26-2008 03:50 AM
help me in sending parameters from sqlplus script to unix shell script	Hara	Shell Programming and Scripting	2	01-29-2008 03:31 PM
Shell Script: want to insert values in database when update script runs	ring	Shell Programming and Scripting	1	10-25-2007 04:06 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by