Shell Programming and Scripting

I wanna create a millions of record using shell scripts..
the scenario is somehow like this,,,i want to create the record for these fields in my database..id,name,addrs,sales.
So can you please give a overall idea for how to achieve it?

How about using a PL/SQL instead?

If field ID is primary key in your table, then use a PL/SQL for loop to generate and insert 1M IDs:-

Code:

for i in 1..1000000 loop
    insert into your_table values (i,'name','addrs','sales');
end loop;
commit;

bipin: Aren't the name and other details suppose to change??

If you want to use file as external table then below one is also can be good option :

i=1; while [ $i -lt 10 ]; do echo "$i , $i name ,$i address , $i sales , "; ((i=$i+1)) done >> E_your_table

You will get below result
1 , 1 name ,1 address , 1 sales ,
2 , 2 name ,2 address , 2 sales ,
3 , 3 name ,3 address , 3 sales ,
4 , 4 name ,4 address , 4 sales ,
5 , 5 name ,5 address , 5 sales ,
6 , 6 name ,6 address , 6 sales ,
7 , 7 name ,7 address , 7 sales ,
8 , 8 name ,8 address , 8 sales ,
9 , 9 name ,9 address , 9 sales ,

Hope you find this useful .

I guess the user want this to conduct a performance test, in that case user just need a million records with unique ids. So what difference will it make having other details changed?

Thanks bipin and all for revert back to this post.Not only id's but i wanna create million record for every fields.First i wanna save that into a csv file den i will export.Is that possible to create those number of record with unique id.

You can use the solution provided by kailas.girase