實(shí)驗(yàn)三高級(jí)sql語言

1、實(shí)驗(yàn)三：高級(jí)實(shí)驗(yàn)三：高級(jí)SQLSQL語言語言1.1.實(shí)驗(yàn)?zāi)康膶?shí)驗(yàn)?zāi)康氖煜cle10g關(guān)于層次、情景、翻譯、分析、線性回歸等各種高級(jí)查詢技術(shù)。2.2.實(shí)驗(yàn)內(nèi)容實(shí)驗(yàn)內(nèi)容（1）練習(xí)層次查詢；（2）練習(xí)情景查詢；（3）練習(xí)翻譯查詢；（4）練習(xí)分析查詢；（5）練習(xí)線性回歸查詢。3.3.實(shí)驗(yàn)步驟實(shí)驗(yàn)步驟層次查詢層次查詢createtablebicycle(part_idnumber(5)constraintpk_bicycle_part_idpr

2、imarykeyparent_idnumber(5)constraintfk_bicycle_pidreferencesbicycle(part_id)part_namevar2(30)notnullmp_costnumber(92)describevar2(30))intobicyclevalues(1null自行車379.28裝配)intobicyclevalues(21導(dǎo)向系統(tǒng)101.11制造)intobicyclevalues(

3、31驅(qū)動(dòng)系統(tǒng)159.56制造)intobicyclevalues(41其他部分118.61制造和采購)intobicyclevalues(52車把37.28制造)intobicyclevalues(62前叉24.35制造)intobicyclevalues(72前軸19.67制造)intobicyclevalues(82前輪19.81制造)intobicyclevalues(97前軸棍8.16制造)intobicyclevalues(1

4、07前軸身4.82制造)intobicyclevalues(117前軸碗6.69制造)intobicyclevalues(1210前軸管1.61制造)intobicyclevalues(1310前花盤3.21制造)intobicyclevalues(143腳蹬18.99制造)intobicyclevalues(153中軸25.27制造)intobicyclevalues(163鏈條21.65制造)intobicyclevalues(17

5、3飛輪29.12制造)intobicyclevalues(183后軸31.72制造)intobicyclevalues(193后輪32.81制造)intobicyclevalues(2017外套9.35制造)intobicyclevalues(2117平檔5.82制造)connectbypripart_id=parent_idlevellpad(3level1)||part_nameaspartNamemp_costfrombicycl

6、estartwithpart_id=(part_idfrombicyclewherepart_namelike%花盤%)connectbypriparent_id=part_idlevellpad(3level1)||part_nameaspartNamemp_costfrombicyclewherepart_name驅(qū)動(dòng)系統(tǒng)levellpad(3level1)||part_nameaspartNamemp_costfrombicycl