使用PL/SQL工具
第一种方法 (表 用了别名)
Insert into sajet.g_sn_keyparts a(SERIAL_NUMBER, ITEM_PART_SN)
select * from (
select 'V99999', '11111' from dual union all
select 'V99999', '22222' from dual union all
select 'V99999', '33333' from dual
)
第二种 (表 没用别名)
Insert all
Into sajet.g_sn_keyparts (SERIAL_NUMBER, ITEM_PART_SN) values('V99999', '44444')
Into sajet.g_sn_keyparts (SERIAL_NUMBER, ITEM_PART_SN) values('V99999', '55555')
Into sajet.g_sn_keyparts (SERIAL_NUMBER, ITEM_PART_SN) values('V99999', '99999')
SELECT * from dual;
使用如下语句查询即可
select * FROM sajet.g_sn_keyparts a WHERE SERIAL_NUMBER = 'V99999'