數(shù)據(jù)庫(kù)實(shí)驗(yàn)報(bào)告2(編輯修改稿)
2024-08-17 11:37 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 es ADD CONSTRAINT clength CHEAK(length=60 AND length=250)。添加要求的視圖和索引：⑤CREATE VIEW RichExec AS SELECT name,address,cert,netWorth FROM MovieExec WHERE netWorth=10000000。⑥CREATE VIEW StudioPress AS SELECT ,cert FROM MovieExec,Studio WHERE =。⑦CREATE VIEW ExecutiveStar AS SELECT , ,gender,birthdate,netWorth FROM MovieStar,MovieExec WHERE = AND =。⑧CREATE INDEX aindex ON StarsIn(StarName)。調(diào)用存儲(chǔ)過(guò)程（函數(shù)），求Laptop內(nèi)存容量的平均值和總和。 create function laptop() returns setof realas $$declare ramcount int :=0。sum int:=0。ramloop int。
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1