Batch insert data records (resource_id, store_code, store_name, store_type, is_stop, address, tel, mobile, emp_code, financial_staff, is_dealers) selectsys_guid (), CK-| to_char (rownum ), test repository | to_char (rownum), computer storage repository, no,
Batch insert data Oracle insert into t_store (resource_id, store_code, store_name, store_type, is_stop, address, tel, mobile, emp_code, financial_staff, is_dealers) select sys_guid (), 'ck-'| to_char (rownum), 'test warehouse' | to_char (rownum), 'computer storage warehouse ', 'No ',
Batch insert data to Oracle
Insert into t_store (resource_id, store_code, store_name, store_type, is_stop, address, tel, mobile, emp_code, financial_staff, is_dealers) select sys_guid (), 'ck-'| to_char (rownum), 'test warehouse' | to_char (rownum), 'computer storage warehouse ', 'No', 'shenyang city, Liaoning Province ','', '123', 'wang Jingjing ', 'lily', 'no' from dual connect by level <= 15014289899