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

11周实验Oracle10g表和约束的操作命令实验要求：3如下1、开启oracle服务(桌面上.bat文件->配置和本地命名服务-->安装plsql并汉化-->用system账户，jsjxjf登陆orcl数据库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'统一价';commentoncolumnTBPRODUCT.pricehy is'会员价';commentoncolumnTBPRODUCT.pdtdescribeis'商品描述';--------TBCARTcommentoncolumnTBCART.id is'序号';commentoncolumnTBCART.userid is'会员编号';commentoncolumnTBCART.productidis'商品编号';commentoncolumnTBCART.num is'数量';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','