genrec.awk

一本介绍oracle的书籍

END {
    srand();

    USER_INFO="user_info.ctl";
    printf("load data\ninfile *\nappend\ninto table user_info\nfields terminated by '|'\n(\n\tloginname\t\tchar(12),\n\tcreate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tupdate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tstatus\t\tchar(1),\n\tpassword\t\tchar(8),\t\n\tnickname\t\tchar(20),\n\tregister_dt\tchar(8),\n\tage\t\tinteger external,\n\tincome\t\tinteger external,\n\temail\t\tchar(30),\n\taddress\t\tchar(100),\n\tintroduction\t\tchar(500)\n)\nbegindata\n") > USER_INFO;

    for(i=1; i<=3000000; i++)
    {
        printf("arron%07d|20020101000000|20020101000000|1|%06d|阿隆%07d|20020101|%02d|%012.0lf|[e-mail]|中国上海南京西路%07d号|The Truth Is Out There\n",i,int(rand()*1000000),i,int(rand()*50),rand()*10000,i,i) >> USER_INFO;
    }
}