specifing range....

zedex · #1 (**permalink**) 10-19-2007

hi
i want to create file which will be executed in sqlplus
so consider there are abc[1-100] tables and i want count from all the tables now i used for loop for this for eg.

Code:

for name in dayj dptm tfj{1,2,3,4,5,6,7,8} tfx{1,2,3,4,5,6,7,8}
do
    echo "select count(*) from $name;" >> night_file.sql
done

but how can i specify only range like tfj[1-100] ??

radoulov · #2 (**permalink**) 10-19-2007

Quote:

Originally Posted by zedex

hi
[..]
but how can i specify only range like tfj[1-100] ??

zsh, bash and ksh93 have brace expansion:

Code:

% printf "select count(1) from tfg%d;\n" {1..10}
select count(1) from tfg1;
select count(1) from tfg2;
select count(1) from tfg3;
select count(1) from tfg4;
select count(1) from tfg5;
select count(1) from tfg6;
select count(1) from tfg7;
select count(1) from tfg8;
select count(1) from tfg9;
select count(1) from tfg10;

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Sed Range Issue	Wrathe	Shell Programming and Scripting	2	06-17-2008 03:54 PM
dhcpd - range parameter	Keene44	IP Networking	1	03-27-2008 01:02 PM
Getting 'out of range' when partitioning	pmichner	UNIX for Dummies Questions & Answers	1	09-30-2006 01:51 AM
Look a string within a range!	azmathshaikh	Shell Programming and Scripting	0	05-01-2005 03:54 AM
Unix SCO 5.0.6 Out of range	josramon	UNIX for Dummies Questions & Answers	5	02-21-2003 02:06 PM

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