HI
I am looking to generate 1 million records as under
272000000001,38129031,982123,0000001
404000000001,38129031,982123,4000001
303000000001,38129031,982123,3000001
282000000001,38129031,982123,1000001
272000000002,38129031,982123,0000002
404000000002,38129031,982123,4000002
303000000002,38129031,982123,3000002
282000000021,38129031,982123,1000002
What would be the best way to do that? i know the seq would not work since it can be used for only one type.
I am looking to generate 1 million records as under
272000000001,38129031,982123,0000001
404000000001,38129031,982123,4000001
303000000001,38129031,982123,3000001
282000000001,38129031,982123,1000001
272000000002,38129031,982123,0000002
404000000002,38129031,982123,4000002
303000000002,38129031,982123,3000002
282000000021,38129031,982123,1000002
What would be the best way to do that? i know the seq would not work since it can be used for only one type.