數(shù)據(jù)庫實驗報告2(編輯修改稿)
2025-08-17 11:37 本頁面
【文章內容簡介】 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)。調用存儲過程（函數(shù)），求Laptop內存容量的平均值和總和。 create function laptop() returns setof realas $$declare ramcount int :=0。sum int:=0。ramloop int。
法律信息相關推薦
鄂ICP備17016276號-1