Oracle习题(插入数据)

https://www.jinchutou.com/p-32807931.html


安装redhat8
https://www.kclouder.cn/rhel8-beta-experience/


select e.empno,e.ename,m.empno,m.ename from emp e,emp m where e.mgr=m.empno(+);? 


像表中插入数据
 insert into product values('M01','佳洁士','8.00','牙膏','宝洁');
 insert into product values('M02','gaorujie','6.50','yagao','gaorujie');
 insert into product values('M03','jienuo','5.00','yagao','lianhelibi');
 insert into product values('M04','shufujia','3.00','xiangzao','baojie');
 insert into product values('M05','xiashilian','5.00','xiangzao','lianhelihua');
 insert into product values('M06','diaopai','2.50','xiyifeng','naaisi');
 inert into product values('M07','zhonghua','3.50','