修改pg中递归写法

现在遇到应用里面有个递归查询的sql，原来在pg里面的写法是：


with t(c_id,c_name,n_level,level) as (
select c_id,c_name,n_level,1 as level from t_test_1 where c_pid is null
union all
select c.c_id,c.c_name,c.n_level,level+1 from t join t_test_1 c on c.c_pid=t.c_id and t.level=level
)
select * from t;

这种with语句很难理解，但是dm有更容易理解的写法

select c.c_id,c.c_name,c.n_level,level 
from   t_test_1 c 
start with c_pid is null
connect by prior c.c_id = c.c_pid;

简单明了，还便于理解，并且Oracle也是支持的。

下面是建表语句和数据。

CREATE TABLE "SYSDBA"."T_TEST_1"
(
 "C_ID" VARCHAR(50) NULL,
 "C_NAME" VARCHAR(150) NULL,
 "C_PID" VARCHAR(50) NULL,
 "N_LEVEL" NUMERIC(3,0) NULL,
 "C_ALIAS" VARCHAR(100) NULL,
 "N_VALID" NUMERIC(3,0) NULL,
 "N_ORDER" NUMERIC(10,0) NULL,
 "DT_UPDATETIME" TIMESTAMP(3) NOT NULL,
 "J_EXT" TEXT NULL,
 "N_DEL" NUMERIC(3,0) NULL,
 "C_DM" VARCHAR(50) NULL,
 "C_GUID" VARCHAR(50) NULL,
 "C_GBM" VARCHAR(100) NULL,
 "C_DZ" VARCHAR(300) NULL,
 "C_YB" VARCHAR(300) NULL
);

INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1049397442','日日结','94b92e44607d431e895483e921e7642e',3,null,1,232,'2019-10-09 16:27:42.252','{"DTUpdatetime":"2019-10-09","CAdmin":"-2"}',2,null,'1049397442',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('0','测试单位00',null,1,null,1,1,'2019-08-06 21:48:20.396','{"DTUpdatetime":"2019-08-06","CAdmin":"1718759404"}',2,null,'0',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('140871093','测试单位01','1727996873',3,'tewt',1,7,'2019-08-13 08:35:32.282','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'140871093',null,'地址','12345');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('141003694','ZZ荷塘hYYdw','140945618',4,null,1,11,'2019-08-13 08:36:22.259','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'141003694',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('839112762','二级单位','778801089',3,null,1,16,'2019-08-21 10:31:31.421','{"CAdmin":"-1"}',2,null,'839112762',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('140945618','湖南省ZZllYYdw','1727996873',3,null,1,8,'2019-08-13 08:35:24.181','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'140945618',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('141017105','ZZ石峰hYYdw','140945618',4,null,1,12,'2019-08-13 08:36:35.672','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'141017105',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('4','ztr测试单位','0',2,null,1,27,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'4',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('59461700171','dppatchdw信息修改','0',1,'简称1',1,29,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','59461700171','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('10466045369','dppatchdw信息修改','0',1,'简称1',1,30,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','10466045369','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('10','郝11','0',2,null,1,40,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-2"}',2,null,'10',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('87903779266','dppatchdw信息修改','0',1,'简称1',1,41,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','87903779266','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('77644915859','dppatchdw信息修改','0',1,'简称1',1,42,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','77644915859','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('140966326','ZZ芙蓉hYYdw','140871093',4,null,1,9,'2019-08-13 08:35:44.889','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'140966326',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('d014cba5da844be68d36d08e4bcd2cd2','删除单位1单位','58439d7e6c20474ca014a60b83b7afa3',3,null,1,22,'2019-08-28 10:26:38.809','{"DTUpdatetime":"2019-08-28","CAdmin":"-1"}',2,null,'d014cba5da844be68d36d08e4bcd2cd2',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1660690291','测试单位sjjy2','1660471275',3,'测试单位sjjy2',1,3,'2019-04-28 16:07:30.716','{"CAdmin":"-2"}',2,null,'1660690291',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1660888553','测试单位sjjy3','1660690291',4,'测试单位sjjy3',1,4,'2019-04-28 16:10:48.977','{"CAdmin":"-2"}',2,null,'1660888553',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1661097831','测试单位sjjy4','1660690291',4,'测试单位sjjy4',1,5,'2019-04-28 16:14:18.253','{"CAdmin":"-2"}',2,null,'1661097831',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1661315634','测试单位sjjy5','1660690291',4,'测试单位sjjy5',1,6,'2019-04-28 16:17:56.058','{"CAdmin":"-2"}',2,null,'1661315634',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1661525393','测试单位sjjy6','1660690291',4,'测试单位sjjy6',1,7,'2019-04-28 16:21:25.817','{"CAdmin":"-2"}',2,null,'1661525393',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1661735731','测试单位sjjy7','1660690291',4,'测试单位sjjy7',1,8,'2019-04-28 16:24:56.156','{"CAdmin":"-2"}',2,null,'1661735731',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1661952065','测试单位sjjy8','1660690291',4,'测试单位sjjy8',1,9,'2019-04-28 16:28:32.489','{"CAdmin":"-2"}',2,null,'1661952065',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1662162804','测试单位sjjy9','1660690291',4,'测试单位sjjy9',1,10,'2019-04-28 16:32:03.228','{"CAdmin":"-2"}',2,null,'1662162804',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1662379814','测试单位sjjy10','1660690291',4,'测试单位sjjy10',1,11,'2019-04-28 16:35:40.238','{"CAdmin":"-2"}',2,null,'1662379814',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1662596265','测试单位sjjy11','1660690291',4,'测试单位sjjy11',1,12,'2019-04-28 16:39:16.689','{"CAdmin":"-2"}',2,null,'1662596265',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1662808665','测试单位sjjy12','1663241559',4,'测试单位sjjy12',1,13,'2019-04-28 16:42:49.089','{"CAdmin":"-2"}',2,null,'1662808665',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1663024610','测试单位sjjy13','1663241559',4,'测试单位sjjy13',1,14,'2019-04-28 16:46:25.034','{"CAdmin":"-2"}',2,null,'1663024610',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1663241559','测试单位sjjy14','1660471275',3,'测试单位sjjy14',1,15,'2019-04-28 16:50:01.984','{"CAdmin":"-2"}',2,null,'1663241559',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1663463520','测试单位sjjy15','1663241559',4,'测试单位sjjy15',1,16,'2019-04-28 16:53:43.945','{"CAdmin":"-2"}',2,null,'1663463520',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1663666788','测试单位sjjy16','1663241559',4,'测试单位sjjy16',1,17,'2019-04-28 16:57:07.212','{"CAdmin":"-2"}',2,null,'1663666788',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1663878761','测试单位sjjy17','1663241559',4,'测试单位sjjy17',1,18,'2019-04-28 17:00:39.185','{"CAdmin":"-2"}',2,null,'1663878761',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1664091424','测试单位sjjy18','1663241559',4,'测试单位sjjy18',1,19,'2019-04-28 17:04:11.848','{"CAdmin":"-2"}',2,null,'1664091424',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1664294633','测试单位sjjy19','1663241559',4,'测试单位sjjy19',1,20,'2019-04-28 17:07:35.057','{"CAdmin":"-2"}',2,null,'1664294633',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1664508388','测试单位sjjy20','1663241559',4,'测试单位sjjy20',1,21,'2019-04-28 17:11:08.813','{"CAdmin":"-2"}',2,null,'1664508388',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('8','郝aaa9','0',2,'aaa9',1,38,'2019-09-29 14:18:54.967','{"DTUpdatetime":"2019-09-29","CAdmin":"-2"}',2,null,'8',null,'aaa9','aaa9');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('41128488855','dppatchdw信息修改','0',1,'简称1',1,222,'2019-09-23 17:08:53.705','{"CDh":"CDh1","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','41128488855','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1664722744','测试单位sjjy21','1663241559',4,'测试单位sjjy21',1,22,'2019-04-28 17:14:43.168','{"CAdmin":"-2"}',2,null,'1664722744',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1664941688','测试单位sjjy22','1663241559',4,'测试单位sjjy22',1,23,'2019-04-28 17:18:22.112','{"CAdmin":"-2"}',2,null,'1664941688',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1665164344','测试单位sjjy23','1663241559',4,'测试单位sjjy23',1,24,'2019-04-28 17:22:04.769','{"CAdmin":"-2"}',2,null,'1665164344',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1665379625','测试单位sjjy24','1665816110',4,'测试单位sjjy24',1,25,'2019-04-28 17:25:40.050','{"CAdmin":"-2"}',2,null,'1665379625',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1665590972','测试单位sjjy25','1665816110',4,'测试单位sjjy25',1,26,'2019-04-28 17:29:11.397','{"CAdmin":"-2"}',2,null,'1665590972',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1665816110','测试单位sjjy26','1660471275',3,'测试单位sjjy26',1,27,'2019-04-28 17:32:56.533','{"CAdmin":"-2"}',2,null,'1665816110',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1666042586','测试单位sjjy27','1665816110',4,'测试单位sjjy27',1,28,'2019-04-28 17:36:43.008','{"CAdmin":"-2"}',2,null,'1666042586',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1666265935','测试单位sjjy28','1665816110',4,'测试单位sjjy28',1,29,'2019-04-28 17:40:26.359','{"CAdmin":"-2"}',2,null,'1666265935',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1666491476','测试单位sjjy29','1665816110',4,'测试单位sjjy29',1,30,'2019-04-28 17:44:11.900','{"CAdmin":"-2"}',2,null,'1666491476',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1666715962','测试单位sjjy30','1665816110',4,'测试单位sjjy30',1,31,'2019-04-28 17:47:56.385','{"CAdmin":"-2"}',2,null,'1666715962',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1666931264','测试单位sjjy31','1665816110',4,'测试单位sjjy31',1,32,'2019-04-28 17:51:31.689','{"CAdmin":"-2"}',2,null,'1666931264',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1667150777','测试单位sjjy32','1665816110',4,'测试单位sjjy32',1,33,'2019-04-28 17:55:11.201','{"CAdmin":"-2"}',2,null,'1667150777',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1667382212','测试单位sjjy33','1665816110',4,'测试单位sjjy33',1,34,'2019-04-28 17:59:02.637','{"CAdmin":"-2"}',2,null,'1667382212',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1667626580','测试单位sjjy34','1665816110',4,'测试单位sjjy34',1,35,'2019-04-28 18:03:07.004','{"CAdmin":"-2"}',2,null,'1667626580',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1667859807','测试单位sjjy35','1665816110',4,'测试单位sjjy35',1,36,'2019-04-28 18:07:00.229','{"CAdmin":"-2"}',2,null,'1667859807',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1668090455','测试单位sjjy36','1668543609',4,'测试单位sjjy36',1,37,'2019-04-28 18:10:50.880','{"CAdmin":"-2"}',2,null,'1668090455',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1668317596','测试单位sjjy37','1668543609',4,'测试单位sjjy37',1,38,'2019-04-28 18:14:38.021','{"CAdmin":"-2"}',2,null,'1668317596',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1668543609','测试单位sjjy38','1660471275',3,'测试单位sjjy38',1,39,'2019-04-28 18:18:24.033','{"CAdmin":"-2"}',2,null,'1668543609',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1668774831','测试单位sjjy39','1668543609',4,'测试单位sjjy39',1,40,'2019-04-28 18:22:15.255','{"CAdmin":"-2"}',2,null,'1668774831',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1668998668','测试单位sjjy40','1668543609',4,'测试单位sjjy40',1,41,'2019-04-28 18:25:59.093','{"CAdmin":"-2"}',2,null,'1668998668',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1669220950','测试单位sjjy41','1668543609',4,'测试单位sjjy41',1,42,'2019-04-28 18:29:41.375','{"CAdmin":"-2"}',2,null,'1669220950',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1669450257','测试单位sjjy42','1668543609',4,'测试单位sjjy42',1,43,'2019-04-28 18:33:30.678','{"CAdmin":"-2"}',2,null,'1669450257',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1669671161','测试单位sjjy43','1668543609',4,'测试单位sjjy43',1,44,'2019-04-28 18:37:11.585','{"CAdmin":"-2"}',2,null,'1669671161',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1669884785','测试单位sjjy44','1668543609',4,'测试单位sjjy44',1,45,'2019-04-28 18:40:45.210','{"CAdmin":"-2"}',2,null,'1669884785',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1670101103','测试单位sjjy45','1668543609',4,'测试单位sjjy45',1,46,'2019-04-28 18:44:21.527','{"CAdmin":"-2"}',2,null,'1670101103',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1670325260','测试单位sjjy46','1668543609',4,'测试单位sjjy46',1,47,'2019-04-28 18:48:05.685','{"CAdmin":"-2"}',2,null,'1670325260',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1670551575','测试单位sjjy47','1668543609',4,'测试单位sjjy47',1,48,'2019-04-28 18:51:51.997','{"CAdmin":"-2"}',2,null,'1670551575',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1670782173','测试单位sjjy48','1671218078',4,'测试单位sjjy48',1,49,'2019-04-28 18:55:42.597','{"CAdmin":"-2"}',2,null,'1670782173',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1670997961','测试单位sjjy49','1671218078',4,'测试单位sjjy49',1,50,'2019-04-28 18:59:18.386','{"CAdmin":"-2"}',2,null,'1670997961',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1671218078','测试单位sjjy50','1660471275',3,'测试单位sjjy50',1,51,'2019-04-28 19:02:58.502','{"CAdmin":"-2"}',2,null,'1671218078',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1671444171','测试单位sjjy51','1671218078',4,'测试单位sjjy51',1,52,'2019-04-28 19:06:44.595','{"CAdmin":"-2"}',2,null,'1671444171',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1671667908','测试单位sjjy52','1671218078',4,'测试单位sjjy52',1,53,'2019-04-28 19:10:28.332','{"CAdmin":"-2"}',2,null,'1671667908',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1671900723','测试单位sjjy53','1671218078',4,'测试单位sjjy53',1,54,'2019-04-28 19:14:21.148','{"CAdmin":"-2"}',2,null,'1671900723',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1672139545','测试单位sjjy54','1671218078',4,'测试单位sjjy54',1,55,'2019-04-28 19:18:19.969','{"CAdmin":"-2"}',2,null,'1672139545',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1672367496','测试单位sjjy55','1671218078',4,'测试单位sjjy55',1,56,'2019-04-28 19:22:07.921','{"CAdmin":"-2"}',2,null,'1672367496',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1672597114','测试单位sjjy56','1671218078',4,'测试单位sjjy56',1,57,'2019-04-28 19:25:57.537','{"CAdmin":"-2"}',2,null,'1672597114',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1673983320','测试单位sjjy62','1660471275',3,'测试单位sjjy62',1,63,'2019-04-28 19:49:03.745','{"CAdmin":"-2"}',2,null,'1673983320',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1674437468','测试单位sjjy64','1673983320',4,'测试单位sjjy64',1,65,'2019-04-28 19:56:37.893','{"CAdmin":"-2"}',2,null,'1674437468',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1679279417','测试单位sjjy85','1679496336',4,'测试单位sjjy85',1,86,'2019-04-28 21:17:19.842','{"CAdmin":"-2"}',2,null,'1679279417',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1683497699','测试单位sjjy104','1682185930',4,'测试单位sjjy104',1,105,'2019-04-28 22:27:38.125','{"CAdmin":"-2"}',2,null,'1683497699',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1672834106','测试单位sjjy57','1671218078',4,'测试单位sjjy57',1,58,'2019-04-28 19:29:54.530','{"CAdmin":"-2"}',2,null,'1672834106',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1673063152','测试单位sjjy58','1671218078',4,'测试单位sjjy58',1,59,'2019-04-28 19:33:43.576','{"CAdmin":"-2"}',2,null,'1673063152',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1673290435','测试单位sjjy59','1671218078',4,'测试单位sjjy59',1,60,'2019-04-28 19:37:30.859','{"CAdmin":"-2"}',2,null,'1673290435',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1673511143','测试单位sjjy60','1673983320',4,'测试单位sjjy60',1,61,'2019-04-28 19:41:11.566','{"CAdmin":"-2"}',2,null,'1673511143',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1673750046','测试单位sjjy61','1673983320',4,'测试单位sjjy61',1,62,'2019-04-28 19:45:10.472','{"CAdmin":"-2"}',2,null,'1673750046',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1674207906','测试单位sjjy63','1673983320',4,'测试单位sjjy63',1,64,'2019-04-28 19:52:48.331','{"CAdmin":"-2"}',2,null,'1674207906',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1675375719','测试单位sjjy68','1673983320',4,'测试单位sjjy68',1,69,'2019-04-28 20:12:16.142','{"CAdmin":"-2"}',2,null,'1675375719',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1675840005','测试单位sjjy70','1673983320',4,'测试单位sjjy70',1,71,'2019-04-28 20:20:00.430','{"CAdmin":"-2"}',2,null,'1675840005',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1676538228','测试单位sjjy73','1676765513',4,'测试单位sjjy73',1,74,'2019-04-28 20:31:38.650','{"CAdmin":"-2"}',2,null,'1676538228',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1676765513','测试单位sjjy74','1660471275',3,'测试单位sjjy74',1,75,'2019-04-28 20:35:25.938','{"CAdmin":"-2"}',2,null,'1676765513',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1677001997','测试单位sjjy75','1676765513',4,'测试单位sjjy75',1,76,'2019-04-28 20:39:22.420','{"CAdmin":"-2"}',2,null,'1677001997',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1678598327','测试单位sjjy82','1676765513',4,'测试单位sjjy82',1,83,'2019-04-28 21:05:58.752','{"CAdmin":"-2"}',2,null,'1678598327',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1679496336','测试单位sjjy86','1660471275',3,'测试单位sjjy86',1,87,'2019-04-28 21:20:56.759','{"CAdmin":"-2"}',2,null,'1679496336',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1680623939','测试单位sjjy91','1679496336',4,'测试单位sjjy91',1,92,'2019-04-28 21:39:44.361','{"CAdmin":"-2"}',2,null,'1680623939',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1681082825','测试单位sjjy93','1679496336',4,'测试单位sjjy93',1,94,'2019-04-28 21:47:23.249','{"CAdmin":"-2"}',2,null,'1681082825',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1682185930','测试单位sjjy98','1660471275',3,'测试单位sjjy98',1,99,'2019-04-28 22:05:46.355','{"CAdmin":"-2"}',2,null,'1682185930',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1682396470','测试单位sjjy99','1682185930',4,'测试单位sjjy99',1,100,'2019-04-28 22:09:16.894','{"CAdmin":"-2"}',2,null,'1682396470',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1682618946','测试单位sjjy100','1682185930',4,'测试单位sjjy100',1,101,'2019-04-28 22:12:59.371','{"CAdmin":"-2"}',2,null,'1682618946',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1679715563','测试单位sjjy87','1679496336',4,'测试单位sjjy87',1,88,'2019-04-28 21:24:35.988','{"CAdmin":"-2"}',2,null,'1679715563',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1681747576','测试单位sjjy96','1682185930',4,'测试单位sjjy96',1,97,'2019-04-28 21:58:28.000','{"CAdmin":"-2"}',2,null,'1681747576',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1683061673','测试单位sjjy102','1682185930',4,'测试单位sjjy102',1,103,'2019-04-28 22:20:22.096','{"CAdmin":"-2"}',2,null,'1683061673',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1683277092','测试单位sjjy103','1682185930',4,'测试单位sjjy103',1,104,'2019-04-28 22:23:57.517','{"CAdmin":"-2"}',2,null,'1683277092',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1674672605','测试单位sjjy65','1673983320',4,'测试单位sjjy65',1,66,'2019-04-28 20:00:33.029','{"CAdmin":"-2"}',2,null,'1674672605',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1674904223','测试单位sjjy66','1673983320',4,'测试单位sjjy66',1,67,'2019-04-28 20:04:24.648','{"CAdmin":"-2"}',2,null,'1674904223',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1675140232','测试单位sjjy67','1673983320',4,'测试单位sjjy67',1,68,'2019-04-28 20:08:20.658','{"CAdmin":"-2"}',2,null,'1675140232',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1675609164','测试单位sjjy69','1673983320',4,'测试单位sjjy69',1,70,'2019-04-28 20:16:09.589','{"CAdmin":"-2"}',2,null,'1675609164',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1676071584','测试单位sjjy71','1673983320',4,'测试单位sjjy71',1,72,'2019-04-28 20:23:52.009','{"CAdmin":"-2"}',2,null,'1676071584',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1676310593','测试单位sjjy72','1676765513',4,'测试单位sjjy72',1,73,'2019-04-28 20:27:51.018','{"CAdmin":"-2"}',2,null,'1676310593',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1677229944','测试单位sjjy76','1676765513',4,'测试单位sjjy76',1,77,'2019-04-28 20:43:10.368','{"CAdmin":"-2"}',2,null,'1677229944',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1677455564','测试单位sjjy77','1676765513',4,'测试单位sjjy77',1,78,'2019-04-28 20:46:55.988','{"CAdmin":"-2"}',2,null,'1677455564',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1677915819','测试单位sjjy79','1676765513',4,'测试单位sjjy79',1,80,'2019-04-28 20:54:36.243','{"CAdmin":"-2"}',2,null,'1677915819',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1678144193','测试单位sjjy80','1676765513',4,'测试单位sjjy80',1,81,'2019-04-28 20:58:24.617','{"CAdmin":"-2"}',2,null,'1678144193',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1678370274','测试单位sjjy81','1676765513',4,'测试单位sjjy81',1,82,'2019-04-28 21:02:10.699','{"CAdmin":"-2"}',2,null,'1678370274',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1679938030','测试单位sjjy88','1679496336',4,'测试单位sjjy88',1,89,'2019-04-28 21:28:18.454','{"CAdmin":"-2"}',2,null,'1679938030',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1680162093','测试单位sjjy89','1679496336',4,'测试单位sjjy89',1,90,'2019-04-28 21:32:02.517','{"CAdmin":"-2"}',2,null,'1680162093',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1680388899','测试单位sjjy90','1679496336',4,'测试单位sjjy90',1,91,'2019-04-28 21:35:49.323','{"CAdmin":"-2"}',2,null,'1680388899',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1680857931','测试单位sjjy92','1679496336',4,'测试单位sjjy92',1,93,'2019-04-28 21:43:38.354','{"CAdmin":"-2"}',2,null,'1680857931',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1681311061','测试单位sjjy94','1679496336',4,'测试单位sjjy94',1,95,'2019-04-28 21:51:11.485','{"CAdmin":"-2"}',2,null,'1681311061',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1681528108','测试单位sjjy95','1679496336',4,'测试单位sjjy95',1,96,'2019-04-28 21:54:48.533','{"CAdmin":"-2"}',2,null,'1681528108',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1681972598','测试单位sjjy97','1682185930',4,'测试单位sjjy97',1,98,'2019-04-28 22:02:13.022','{"CAdmin":"-2"}',2,null,'1681972598',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1682840320','测试单位sjjy101','1682185930',4,'测试单位sjjy101',1,102,'2019-04-28 22:16:40.744','{"CAdmin":"-2"}',2,null,'1682840320',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1683723267','测试单位sjjy105','1682185930',4,'测试单位sjjy105',1,106,'2019-04-28 22:31:23.691','{"CAdmin":"-2"}',2,null,'1683723267',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1683955109','测试单位sjjy106','1682185930',4,'测试单位sjjy106',1,107,'2019-04-28 22:35:15.533','{"CAdmin":"-2"}',2,null,'1683955109',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1684187412','测试单位sjjy107','1682185930',4,'测试单位sjjy107',1,108,'2019-04-28 22:39:07.837','{"CAdmin":"-2"}',2,null,'1684187412',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1684425565','测试单位sjjy108','1684895730',4,'测试单位sjjy108',1,109,'2019-04-28 22:43:05.988','{"CAdmin":"-2"}',2,null,'1684425565',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1684663241','测试单位sjjy109','1684895730',4,'测试单位sjjy109',1,110,'2019-04-28 22:47:03.665','{"CAdmin":"-2"}',2,null,'1684663241',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1684895730','测试单位sjjy110','1660471275',3,'测试单位sjjy110',1,111,'2019-04-28 22:50:56.154','{"CAdmin":"-2"}',2,null,'1684895730',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1685123357','测试单位sjjy111','1684895730',4,'测试单位sjjy111',1,112,'2019-04-28 22:54:43.781','{"CAdmin":"-2"}',2,null,'1685123357',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1685358435','测试单位sjjy112','1684895730',4,'测试单位sjjy112',1,113,'2019-04-28 22:58:38.858','{"CAdmin":"-2"}',2,null,'1685358435',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1685601684','测试单位sjjy113','1684895730',4,'测试单位sjjy113',1,114,'2019-04-28 23:02:42.109','{"CAdmin":"-2"}',2,null,'1685601684',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1685832570','测试单位sjjy114','1684895730',4,'测试单位sjjy114',1,115,'2019-04-28 23:06:32.993','{"CAdmin":"-2"}',2,null,'1685832570',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1686071670','测试单位sjjy115','1684895730',4,'测试单位sjjy115',1,116,'2019-04-28 23:10:32.095','{"CAdmin":"-2"}',2,null,'1686071670',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1686313922','测试单位sjjy116','1684895730',4,'测试单位sjjy116',1,117,'2019-04-28 23:14:34.347','{"CAdmin":"-2"}',2,null,'1686313922',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1686553620','测试单位sjjy117','1684895730',4,'测试单位sjjy117',1,118,'2019-04-28 23:18:34.044','{"CAdmin":"-2"}',2,null,'1686553620',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1677682575','测试单位sjjy78','1676765513',4,'测试单位sjjy78',1,79,'2019-04-28 20:50:42.999','{"CAdmin":"-2"}',2,null,'1677682575',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1678824630','测试单位sjjy83','1676765513',4,'测试单位sjjy83',1,84,'2019-04-28 21:09:45.054','{"CAdmin":"-2"}',2,null,'1678824630',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1679052410','测试单位sjjy84','1679496336',4,'测试单位sjjy84',1,85,'2019-04-28 21:13:32.833','{"CAdmin":"-2"}',2,null,'1679052410',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1686796614','测试单位sjjy118','1684895730',4,'测试单位sjjy118',1,119,'2019-04-28 23:22:37.038','{"CAdmin":"-2"}',2,null,'1686796614',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1687043220','测试单位sjjy119','1684895730',4,'测试单位sjjy119',1,120,'2019-04-28 23:26:43.644','{"CAdmin":"-2"}',2,null,'1687043220',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1687281031','测试单位sjjy120','1687764410',4,'测试单位sjjy120',1,121,'2019-04-28 23:30:41.455','{"CAdmin":"-2"}',2,null,'1687281031',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1687524647','测试单位sjjy121','1687764410',4,'测试单位sjjy121',1,122,'2019-04-28 23:34:45.071','{"CAdmin":"-2"}',2,null,'1687524647',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1687764410','测试单位sjjy122','1660471275',3,'测试单位sjjy122',1,123,'2019-04-28 23:38:44.834','{"CAdmin":"-2"}',2,null,'1687764410',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1688011065','测试单位sjjy123','1687764410',4,'测试单位sjjy123',1,124,'2019-04-28 23:42:51.488','{"CAdmin":"-2"}',2,null,'1688011065',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1688257910','测试单位sjjy124','1687764410',4,'测试单位sjjy124',1,125,'2019-04-28 23:46:58.333','{"CAdmin":"-2"}',2,null,'1688257910',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1688492529','测试单位sjjy125','1687764410',4,'测试单位sjjy125',1,126,'2019-04-28 23:50:52.954','{"CAdmin":"-2"}',2,null,'1688492529',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1688733650','测试单位sjjy126','1687764410',4,'测试单位sjjy126',1,127,'2019-04-28 23:54:54.073','{"CAdmin":"-2"}',2,null,'1688733650',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1689012263','测试单位sjjy127','1687764410',4,'测试单位sjjy127',1,128,'2019-04-28 23:59:32.686','{"CAdmin":"-2"}',2,null,'1689012263',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1689248831','测试单位sjjy128','1687764410',4,'测试单位sjjy128',1,129,'2019-04-29 00:03:29.256','{"CAdmin":"-2"}',2,null,'1689248831',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1689487444','测试单位sjjy129','1687764410',4,'测试单位sjjy129',1,130,'2019-04-29 00:07:27.869','{"CAdmin":"-2"}',2,null,'1689487444',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1689728690','测试单位sjjy130','1687764410',4,'测试单位sjjy130',1,131,'2019-04-29 00:11:29.114','{"CAdmin":"-2"}',2,null,'1689728690',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1689969252','测试单位sjjy131','1687764410',4,'测试单位sjjy131',1,132,'2019-04-29 00:15:29.676','{"CAdmin":"-2"}',2,null,'1689969252',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1690209292','测试单位sjjy132','1690709617',4,'测试单位sjjy132',1,133,'2019-04-29 00:19:29.716','{"CAdmin":"-2"}',2,null,'1690209292',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1690464960','测试单位sjjy133','1690709617',4,'测试单位sjjy133',1,134,'2019-04-29 00:23:45.384','{"CAdmin":"-2"}',2,null,'1690464960',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1690709617','测试单位sjjy134','1660471275',3,'测试单位sjjy134',1,135,'2019-04-29 00:27:50.040','{"CAdmin":"-2"}',2,null,'1690709617',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1690969450','测试单位sjjy135','1690709617',4,'测试单位sjjy135',1,136,'2019-04-29 00:32:09.875','{"CAdmin":"-2"}',2,null,'1690969450',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1691221769','测试单位sjjy136','1690709617',4,'测试单位sjjy136',1,137,'2019-04-29 00:36:22.192','{"CAdmin":"-2"}',2,null,'1691221769',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1691474391','测试单位sjjy137','1690709617',4,'测试单位sjjy137',1,138,'2019-04-29 00:40:34.816','{"CAdmin":"-2"}',2,null,'1691474391',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1691721547','测试单位sjjy138','1690709617',4,'测试单位sjjy138',1,139,'2019-04-29 00:44:41.971','{"CAdmin":"-2"}',2,null,'1691721547',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1691967953','测试单位sjjy139','1690709617',4,'测试单位sjjy139',1,140,'2019-04-29 00:48:48.378','{"CAdmin":"-2"}',2,null,'1691967953',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1692234771','测试单位sjjy140','1690709617',4,'测试单位sjjy140',1,141,'2019-04-29 00:53:15.195','{"CAdmin":"-2"}',2,null,'1692234771',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1692475124','测试单位sjjy141','1690709617',4,'测试单位sjjy141',1,142,'2019-04-29 00:57:15.549','{"CAdmin":"-2"}',2,null,'1692475124',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1692741274','测试单位sjjy142','1690709617',4,'测试单位sjjy142',1,143,'2019-04-29 01:01:41.698','{"CAdmin":"-2"}',2,null,'1692741274',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1692976459','测试单位sjjy143','1690709617',4,'测试单位sjjy143',1,144,'2019-04-29 01:05:36.884','{"CAdmin":"-2"}',2,null,'1692976459',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1693222662','测试单位sjjy144','1693697375',4,'测试单位sjjy144',1,145,'2019-04-29 01:09:43.086','{"CAdmin":"-2"}',2,null,'1693222662',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1693459463','测试单位sjjy145','1693697375',4,'测试单位sjjy145',1,146,'2019-04-29 01:13:39.889','{"CAdmin":"-2"}',2,null,'1693459463',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1693697375','测试单位sjjy146','1660471275',3,'测试单位sjjy146',1,147,'2019-04-29 01:17:37.800','{"CAdmin":"-2"}',2,null,'1693697375',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1693940983','测试单位sjjy147','1693697375',4,'测试单位sjjy147',1,148,'2019-04-29 01:21:41.407','{"CAdmin":"-2"}',2,null,'1693940983',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1694208666','测试单位sjjy148','1693697375',4,'测试单位sjjy148',1,149,'2019-04-29 01:26:09.091','{"CAdmin":"-2"}',2,null,'1694208666',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1694451851','测试单位sjjy149','1693697375',4,'测试单位sjjy149',1,150,'2019-04-29 01:30:12.276','{"CAdmin":"-2"}',2,null,'1694451851',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1694699249','测试单位sjjy150','1693697375',4,'测试单位sjjy150',1,151,'2019-04-29 01:34:19.674','{"CAdmin":"-2"}',2,null,'1694699249',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('960756802','郝1-1','8',3,null,1,38,'2019-09-16 16:45:55.308','{"DTUpdatetime":"2019-09-16","CAdmin":"-2"}',2,null,'960756802',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('140986712','ZZ天心hYYdw','140871093',4,null,1,10,'2019-08-13 08:36:05.278','{"DTUpdatetime":"2019-08-13","CAdmin":"-1"}',2,null,'140986712',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('2146619087','单位hcl','1718476641',3,null,1,32,'2019-09-05 13:39:30.236','{"DTUpdatetime":"2019-09-05","CAdmin":"-1"}',2,null,'2146619087',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('7','hzg测试','0',2,null,1,36,'2019-09-16 14:02:08.810','{"DTUpdatetime":"2019-09-16","CAdmin":"-2"}',1,null,'7',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('5','移动单位','0',2,null,1,3,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-2"}',2,null,'5',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1718476641','hcl','0',2,null,1,8,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1;182531880"}',2,null,'1718476641',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('11','邹余测试单位一','0',2,null,1,14,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"595131726"}',2,null,'11',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('12','邹余测试单位二','0',2,null,1,15,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"595131726"}',2,null,'12',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('c7c770e6c9a24cf3bc0e68f55c23ee7e','测试单位一','0',2,null,1,20,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'c7c770e6c9a24cf3bc0e68f55c23ee7e',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('63363041056','dppatchdw信息修改','0',1,'简称1',1,31,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','63363041056','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('18908409607','dppatchdw信息修改','0',1,'简称1',1,43,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','18908409607','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('13256081313','dppatchdw信息修改','0',1,'简称1',1,222,'2019-09-23 17:06:33.400','{"CDh":"CDh1","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','13256081313','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('960766725','郝1-1-1','960756802',4,null,1,39,'2019-09-16 16:46:05.230','{"DTUpdatetime":"2019-09-16","CAdmin":"-2"}',2,null,'960766725',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('755284842','王朝系列','0',2,null,1,10,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'755284842',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('771603229','登录标识单位','0',2,null,1,11,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'771603229',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('778801089','接口单位','0',2,null,1,12,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'778801089',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('841606526','吴云飞的测试单位','0',2,null,1,13,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"96541468"}',2,null,'841606526',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('871506358','小corp1','0',2,null,1,16,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'871506358',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('81937275904','dppatchdw信息修改','0',1,'简称1',1,32,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','81937275904','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('26811063388','dppatchdw信息修改','0',1,'简称1',1,44,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','26811063388','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('59594325414','dppatchdw信息修改','0',1,'简称1',1,45,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','59594325414','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('60539340318','dppatchdw信息修改','0',1,'简称1',1,222,'2019-09-23 17:10:37.612','{"CDh":"CDh1","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','60539340318','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('65784682334','dppatchdw信息修改','0',1,'简称1',1,222,'2019-09-23 17:02:24.621','{"CDh":"CDh1","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','65784682334','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('960795503','郝1-1-1-1','960766725',5,null,1,40,'2019-09-16 16:46:34.007','{"DTUpdatetime":"2019-09-16","CAdmin":"-2"}',2,null,'960795503',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('13','mm测试单位','0',2,'mm',1,47,'2019-09-17 19:00:27.975','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'13',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('6','举杯邀明月2','0',2,null,1,1,'2019-09-19 16:57:26.803','{"DTUpdatetime":"2019-09-19","CAdmin":"-1"}',2,null,'6',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1727996873','湖南省高级YYdw','0',2,'tester',1,4,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'1727996873',null,'123131','15614515321');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1725130327','ZZ高级YYdw','0',2,'bjgyrmfy',1,5,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'1725130327',null,'北京市海淀区','123123');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1717962635','kail啦啦啦啦啦啦啦啦啦啦啦啦啦','0',2,null,1,6,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1;182531880;-5"}',2,null,'1717962635',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1660471275','测试单位sjjy1','0',2,'测试单位sjjy1',1,7,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-2"}',2,null,'1660471275',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('1718823828','zyytestcorp','0',2,null,1,9,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17"}',2,null,'1718823828',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('51444060519','dppatchdw信息修改','0',1,'简称1',1,33,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','51444060519','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('11967416045','dppatchdw信息修改','0',1,'简称1',1,34,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','11967416045','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('29479215264','dppatchdw信息修改','0',1,'简称1',1,46,'2019-09-17 13:53:08.181','{"CDh":"CDh1","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','29479215264','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('21659030068','dppatchdw信息修改','0',1,'简称1',1,222,'2019-09-23 16:57:41.819','{"CDh":"CDh1","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh1","CKhzh":"CKhzh1"}',2,'CDm1','21659030068','CGbm1','CDz1','CYb1');
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('3','挂职单位','0',2,null,1,2,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-2"}',2,null,'3',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('871513247','小corp2','0',2,null,1,17,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'871513247',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('58439d7e6c20474ca014a60b83b7afa3','测试单位删除1','0',2,null,1,18,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'58439d7e6c20474ca014a60b83b7afa3',null,null,null);
INSERT INTO "SYSDBA"."T_TEST_1" VALUES('3dc546a125d54068989c5a05eed5cd9f','测试单位删除2','0',2,null,1,19,'2019-09-17 13:53:08.181','{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}',2,null,'3dc546a125d54068989c5a05eed5cd9f',null,null

作者