期望结果
--【建表语句】
create table TEST_TABLE(
gid varchar2(32),--主键
id_number varchar2(5),--每个车辆都有一个唯一的id号
check_date date, --商品质检日期
unit_name varchar2(32), --责任单位{比如 : 焊装、涂装、总装}
check_part varchar2(32), --商品检验3大检验点 {比如 : 划伤 、油漆 、 装配}
has_bug varchar2(32),--有无缺陷 {0: 默认值,代表商品在此检验点合格 ,反之则为 1:代表此检测不合格 }
question_desc varchar2(32)--检验问题描述
)
--【插入数据】
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adc88875ec3675e015fc5f810d70ba9', 'J0001', to_date('19-05-2018 14:05:29', 'dd-mm-yyyy hh24:mi:ss'), '焊装', '划伤', '1', '左前门划伤');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8ade88875ec3875e015ee5f810d70ba9', 'J0002', to_date('19-05-2018 15:05:29', 'dd-mm-yyyy hh24:mi:ss'), '涂装', '油漆', '1', '侧车身面漆不均');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8add88875ec3975e015ec5f810d70ba9', 'J0003', to_date('19-05-2018 16:05:29', 'dd-mm-yyyy hh24:mi:ss'), '总装', '装配', '1', '装配不当');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf88875ec3975e015ed5f810d70ba9', 'J0003', to_date('20-05-2018 16:05:29', 'dd-mm-yyyy hh24:mi:ss'), '焊装', '划伤', '0', '合格');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf88875ec3975e015ed5f810d70ba9', 'A0001', to_date('20-05-2018 11:05:29', 'dd-mm-yyyy hh24:mi:ss'), '涂装', '油漆', '1', '前盖板面漆不均');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf88475ec3975e015ed5f810d70ba9', 'A0002', to_date('21-05-2018 13:04:29', 'dd-mm-yyyy hh24:mi:ss'), '总装', '装配', '0', '合格');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf83875ec3975e015ed5f810d70ba9', 'K0001', to_date('21-05-2018 13:05:29', 'dd-mm-yyyy hh24:mi:ss'), '焊装', '划伤', '1', '右前门划伤');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf82875ec3975e015ed5f810d70ba9', 'K0002', to_date('21-05-2018 13:08:29', 'dd-mm-yyyy hh24:mi:ss'), '涂装', '油漆', '1', '侧车身面漆不均');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8ad18875ec3975e015ed5f810d70ba9', 'K0003', to_date('21-05-2018 13:12:29', 'dd-mm-yyyy hh24:mi:ss'), '总装', '装配', '1', '装配有误');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf8u875ec3975e015ed5f810d70ba9', 'J0001', to_date('22-05-2018 13:12:29', 'dd-mm-yyyy hh24:mi:ss'), '涂装', '油漆', '1', '侧车身面漆不均');
insert into TEST_TABLE (GID, ID_NUMBER, CHECK_DATE, UNIT_NAME, CHECK_PART, HAS_BUG, QUESTION_DESC)
values ('8adf8u875ec39755015ed5f810d70ba9', 'J0002', to_date('22-05-2018 13:12:29', 'dd-mm-yyyy hh24:mi:ss'), '焊装', '划伤', '1', '左前门划伤');