第11周oracle表和約束的命令信管14某

11周實驗Oracle10g表和約束的操作命令實驗要求：3如下1、開啟oracle服務(wù)(桌面上.bat文件->配置和本地命名服務(wù)-->安裝plsql并漢化-->用system賬戶，jsjxjf登陸orcl數(shù)據(jù)庫2、3的建表語句createtableTBUSERcreatetable（createtableTBCART--------TBUSERcommentoncolumnTBUSER.userid is'會員編號';commentoncolumnTBUSER.usernameis'會員';commentoncolumnTBUSER.passwordis'口令';commentoncolumnTBUSER.type is'會員類型';commentoncolumnTBUSER.provinceis'省';commentoncolumnTBUSER.is'';commentoncolumnTBUSER. is'';commentoncolumnTBUSER.regdate is'日期';--------TBPRODUCTcommentoncolumnTBPRODUCT.productid is'商品編號';commentoncolumnTBPRODUCT.typeid is'類型';commentoncolumnTBPRODUCT.productnameis'商品名稱';commentoncolumnTBPRODUCT.xg is'型號';commentoncolumnTBPRODUCT.pricemarketis'市場參考價';commentoncolumn is'統(tǒng)一價';commentoncolumnTBPRODUCT.pricehy is'會員價';commentoncolumnTBPRODUCT.pdtdescribeis'商品描述';--------TBCARTcommentoncolumnTBCART.id is'序號';commentoncolumnTBCART.userid is'會員編號';commentoncolumnTBCART.productidis'商品編號';commentoncolumnTBCART.num is'數(shù)量';commentoncolumnTBCART.price is'價格';43SQL53SQL63SQL73SQL83SQL9、每錄入5條左右的記錄并截圖2．insertintotbproductinsertintotbproductinsertintotbproductinsertintotbproductinsertintotbproduct3insertintotbcartvalues('6','20151116001','1','default','123','11,22');insertintotbcartvalues('7','20151116002','2','default','123','11,22');insertintotbcartvalues('8','20151116003','3','default','123','11,22');insertintotbcartvalues('9','20151116004','4','default','123','