Oracle代码阅读能力及调试跟踪方法系统考核题
6页1、Oracle代码阅读能力及调试跟踪方法系统考核题答题规则时间:原则上不限,但尽量在连续的4个小时内答完;方式:除了与本次学习的学员沟通、请人代做以外的任意方式,含网络搜索等;(即要求独立解决问题能力)要求:为了对其他学员负责,请先参加考核的学员,不要将考核题及结果转给未参与考核的学员,未参与考核的学员也不要询问考题内容及结果;另,注意署名,且写上答题耗费时间oracle基础数据操作语法C类题一张表中包含如下列属性和记录信息:发生日期业务类型商品代码数量成本金额发生金额发生门店收货门店2011/1/4自营进00001100200.00200.00100000010000002011/2/11自营进0000210001000.001000.00100000010000002011/2/11零售00005100300.00400.00100000010000002011/2/12自营进0000320340.6040.60100000010000002011/2/12溢余000047003500.003500.00100000010000002011/2/12溢余000058002400.00
2、2400.00100000010000002011/2/12零售000052060.0080.00100000010000002011/2/25溢余000069601920.001920.00100000010000002011/3/1统配出000077302920.003500.00100000010000012011/3/6统配出00008220.0025.00100000010000012011/3/7统配出000093001200.001300.00100000010000022011/3/7零售0000650100.00150.00100000010000002011/3/7调拨出000104545.0045.00100000010000002011/3/11调拨出0001110500.00500.00100000010000002011/3/11零售00008770105.00100000010000002011/3/11零售00003204.0010.00100000010000001. 创建该表,表名定义(注意字段名使用英文):创建者姓名全拼音_DRPT;Create
3、TABLE HD40.ZHENGBAOSHAN_DRPT( FASHENG_DATE DATE, YEWULEIXING VARCHAR2(255 BYTE), SHANGPIN_NO NUMBER, SHANGPIN_NUMBER NUMBER, CHENGBEN_JINE NUMBER(8,2), FASHENG_JINE NUMBER(8,2), FASHENG_MENDIAN INTEGER, SHOUHUO_MENDIAN NUMBER)2. 插入表中的记录信息;Insert into zhengbaoshan_drpt values (2011/1/4,自营进,00001,100,200.00,200.00,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/11,自营进,00002,1000,1000.00,1000.00,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/11,零售,00005,100,300.00,400.0
4、0,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/12,自营进,00003,203,40.60,40.60,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/12,溢余,00004,700,3500.00,3500.00,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/12,溢余,00005,800,2400.00,2400.00,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/12,零售,00005,20,60.00,80.00,1000000,1000000);Insert into zhengbaoshan_drpt values (2011/2/25,溢余,00006,960,1920.00,1920.00,1000000,1000000);Insert into zhengba
《Oracle代码阅读能力及调试跟踪方法系统考核题》由会员luobi****88888分享,可在线阅读,更多相关《Oracle代码阅读能力及调试跟踪方法系统考核题》请在金锄头文库上搜索。
2023-09-25 37页
2023-09-25 10页
2023-09-25 33页
2023-09-25 26页
2023-04-03 8页
2023-04-03 4页
2023-04-03 8页
2023-03-29 10页
2023-03-22 10页
2023-03-20 8页