oracle建立一个游戏库,能否用PL/SQL编一个游戏

表和数据

create table words(word varchar(50),flag varchar(1));

alter table words add primary key(word);

--insert into words

insert into words(word)

with s as (select replace(&＃39;

a,about,after,afternoon,again,ago,air,all,along,am,an,and,angry,animal,answer,ant,any,apple,april,are,ask,at,august,aunt,auntie,aunty,autumn,

back,bad,bag,ball,banana,bank,basketball,bathroom,be,bean,bear,beautiful,bed,bee,before,begin,best,between,big,bike,bird,birthday,black,blackboard,blow,blue,boat,book,boots,borrow,bowl,box,boy,bread,breakfast,bright,bring,brother,bus,but,buy,by,bye,

cake,can,car,card,careful,carry,cartoon,cat,chair,cheap,cheese,chess,chick,chicken,child,children,chocolate,city,class,classroom,clean,clear,clearly,clever,climb,clock,close,clothes,coat,coffee,coin,cold,colour,come,come to school,computer,cook,cool,corner,cup,cut,

dad,dance,dark,date,day,dear,december,deer,desk,difference,dirty,do,doctor,dog,door,down,draw,dress,drink,driver,dry,duck,

ear,early,east,eat,egg,eggplant,e-mail,english,enjoy,eraser,evening,every,example,excuse,eye,

face,factory,family,far,farm,farmer,fast,fasten,fat,fax,february,feel,film,find,fine,finger,finish,first,fish,five,flag,flower,fly,follow,food,foot,football,for,fork,fox,friday,friend,fruit,

game,garden,gate,get,girl,give,glass,glasses,go,goat,good,grade,grape,grass,great,green,guess,

hair,half,hall,hand,happy,hard,hare,have,he,head,hear,hello,help,her,here,hers,hi,high,him,his,hold,holiday,home,homework,horse,hospital,hotel,hour,house,how,hundred,hungry,hurry,

i,idea,if,ill,in,ink,interesting,internet,into,is,it,italy,its,

jacket,jane,january,jeep,join,juice,july,jump,june,just,

keep,key,kind,kite,knife,know,

ladder,lady,lake,land,last,late,learn,leave,lend,lesson,let,letter,library,lift,light,like,line,listen,little,live,long,look,lose,love,luck,lunch,

madam,make,man,mango,many,map,march,match,maths,may,maybe,me,meal,meet,meeting,merry,message,middle,milk,mine,minute,mirror,miss,model,mom,moment,monday,money,month,moon,morning,mother,mountain,mouse,mouth,movie,mr,mrs,much,mum,music,must,my,myself,

name,near,neat,need,neighbour,nervous,net,new,news,newspaper,next,nice,night,no,no.,nose,not,nothing,november,now,number,nurse,

october,of,office,often,oh,ok,old,on,one,only,open,or,orange,our,ours,out,outside,over,

panda,paper,parents,park,party,pass,past,peach,pear,pen,pencil,pencil box,pet,phone,photo,piano,picture,pig,place,plane,plate,play,please,post,postcard,postman,potato,price,purse,put,

quarter,question,queue,quiet,

rabbit,radio,rain,raise,read,ready,red,remember,repair,return,right,river,road,room,round,row,ruler,run,

sad,salad,salesman,same,sandwich,saturday,sausage,save,say,school,schoolbag,season,second,see,september,shark,she,sheep,shelf,shell,ship,shoe,shop,shopping,short,should,shy,sick,sing,sister,sit,size,skate,skirt,sleep,slow,small,snail,snake,snow,so,sofa,some,something,son,song,sorry,speak,spell,sport,spring,stamp,stand,star,start,station,stay,stop,store,story,street,student,study,subway,summer,sun,sunday,swim,

table,tail,take,talk,tall,tea,teach,teacher,telephone,television,tell,temperature,tennis,test,thank,that,the,their,theirs,them,then,there,these,they,thick,thin,think,this,those,through,thursday,ticket,tidy,time,to,today,toe,together,tomorrow,too,tooth,toy,train,tree,truck,try,t-shirt,tuesday,turn,tv,

uncle,under,us,use,

very,visit,

wait,walk,wall,want,warm,wash,watch,water,way,we,weather,wednesday,week,welcome,well,wet,what,when,where,which,white,who,whose,why,will,wind,window,winter,with,wolf,woman,women,woods,word,work,worker,world,write,wrong,

yea,yellow,yes,yesterday,you,young,your,yours,

zoo,&＃39;,chr(10))s from dual)

,s1 as(select regexp_substr(s,&＃39;[^,]&＃43;&＃39;, 1,level)s1 from s connect by level<&＃61;regexp_count(s,&＃39;,&＃39;))

select s1 from s1;