ch9_服务器环境下的SQL

1、1234567891011后面是嵌套的后面是嵌套的SQL语句语句共享变量在共享变量在SQL中须加冒中须加冒号作前缀号作前缀12131415161718192021222324MovieExecs (name, address, cert#, netWorth)2526272829EXEC SQL DECLARE execCursor SCROLL CURSOR FOR MovieExec;EXEC SQL OPEN execCursor;EXEC SQL FETCH LAST FROM execCursor INTO :execName, :execAddr, :certNo, :worth;

2、While(1) EXEC SQL FETCH PRIOR FROM execCursor INTO :execName, :execAddr, :certNo, :worth;303132333435363738394041424344变量类型与变量类型与MovieStar模式定义模式定义中中address的类型相的类型相匹配匹配参数名可作常量，参数名可作常量，PSM过程和函数中过程和函数中的参数或别的局部的参数或别的局部变量不要求加冒号变量不要求加冒号4546474849505152可选可选任何布尔类型的表达式任何布尔类型的表达式语句列表由以分号结束语句列表由以分号结束的语句构成，但不必置

3、的语句构成，但不必置于于BEGINEND之间之间535455SET presNetWorth=(SELECT netWorth FROM Studio,MovieExec WHERE presC#=cert# AND S=studioName);5657nxxnii1nxxnii12)(2112)(nxnxniinii596061626364656667686970717273747576777879808182838485868788其他属性分量其他属性分量上只能接受缺上只能接受缺省值或省值或NULL899091929394959697989910010110210310

4、4*表明了该权表明了该权限来自正在讨论的数据库元素的所有权限来自正在讨论的数据库元素的所有权105JanawaySELECT on Movie*JanawayINSERT on Studio*JanawayINSERT on Movie*JanawaySELECT on Studio*KirkSELECT on Studio*KirkINSERTon Studio*PicardSELECT on Studio*PicardINSERTon Studio*KirkSELECT on Movie*PicardSELECT on Movie*SiskoSELECT on StudioSiskoINS

5、ERTon StudioSiskoSELECT on MovieSiskoINSERT(name) on Studio106107108109JanawaySELECT on Movie*JanawayINSERT on Studio*JanawayINSERT on Movie*JanawaySELECT on Studio*KirkSELECT on Studio*KirkINSERTon Studio*PicardSELECT on Studio*PicardINSERTon Studio*KirkSELECT on Movie*PicardSELECT on Movie*SiskoSELECT on StudioSiskoINSERTon StudioSiskoSELECT on MovieSi