Search Results

Thanks for the tips.
The degree of randomness is not critical for me, so the print $RANDOM is fine.
I found Perderabo's script too, but it's probably more than I need at this stage.

Thanks again...

I am trying to find a way to generate random numbers within a shell script.
Does Solaris have a utility that will generate random numbers?

Thanks in advance.
B

Wow radoulov,
That's brilliant. It works perfectly.
This is going to save me so much laborious editing.
I can't thank you enough for your efforts.

Regards
Bob :)

No luck I'm afraid. The file comes from a third party development system, and I need to create a live schema from it with different storage criteria. I'd also use the syntax to change tablespace...

Apologies for the confusion in the original problem statement. I should have given more detail.
The file I am processing contains SQL statements (It's from an Oracle database export).
For each...

The awk script works great thanks, but I've discovered that there may be instances where there is no line of '65536' between the 'alter' lines.
Is there any way to skip to the next 'alter', if a...

Thanks radoulov.
There may be any number of records between the
alter and 65536, so your awk code is on the mark.
I'll check it out first thing tomorrow (and yes, I'm on Solaris)
Do the two...

Hi,
I have a file that I would like to translate using sed.
I can do some basic sed commands, but Im afraid this level is beyond me.
I have this file -
...alter...
..
...65536...
......