数据库原理实验-游标及存储过程.docVIP

数据库实验操作 陈振凯建立EPoem表和CPoem表，并插入数据EPoemThe furthest distance in the world, is not when plainly cannot resist the yearning, yet pretending you have never been in my heartThe furthest distance in the world, is not when plainly cannot resist the yearning, yet pretending you have never been in my heartBut using one’s indifferent heart, to dig an uncrossable river for the one who loves youBut when undoubtedly knowing the love from both, yet cannot be togetherThe furthest distance in the world, is not being apart while being in loveBut when plainly can not resist the yearning, yet pretending you have never been in my heartThe furthest distance in the world, is not when I stand in front of you, yet you can’t see my loveBut when I stand in front of you, yet you don’t know that I love youThe furthest distance in the world, is not between life and deathLineText世界上最遥远的距离，不是明明无法抵挡这股思念，却还要故意装作丝毫没有把你放在心里， 世界上最遥远的距离，不是明明无法抵挡这股思念，却还要故意装作丝毫没有把你放在心里， 而是用自己冷漠的心，对爱你的人掘了一条无法跨越的沟渠 而是明明知道彼此相爱，却不能在一起 世界上最遥远的距离，不是明明知道彼此相爱，却不能在一起 而是明明无法抵挡这股思念，却还得故意装作丝毫没有把你放在心里 世界上最遥远的距离，不是我站在你面前，你却不知道我爱你 而是我就站在你的面前，你却不知道我爱你 世界上最遥远的距离，不是生与死LineText写存储过程read_poem，依次实现如下功能显示 “英文诗”依次显示EPoem的所有记录显示一个空行显示“中文诗”依次显示CPoem的所有记录代码：create table czk_EPoem( LineText char(1000) not null)create table czk_CPoem( LineText char(100) not null)insert into czk_EPoemvalues(The furthest distance in the world, is not between life and death)insert into czk_EPoemvalues(But when I stand in front of you, yet you don’t know that I love you)insert into czk_EPoemvalues(The furthest distance in the world, is not when I stand in front of you, yet you can’t see my love)insert into czk_EPoemvalues(But when undoubtedly knowing the love from both, yet cannot be together)insert into czk_EPoemvalues(The furthest distance in the world, is not being apart while being in love)insert into czk_EPoemvalues(But when plainly can not resist the yearning, yet pretending you have never been in my heart)insert into czk_EPoemvalues(The furthest distanc