declare ret varchar; begin ret = ''; for i in 1..length loop ret = ret || substring ('abcdefghijklmnopqrstuvwxyz1234567890ABCDEFGHIJKLMN' from cast (random()*50 as integer) for 1); end loop; return ret; end