如何改写带with的递归语句

发布时间：2020-08-09 18:57:58 来源：ITPUB博客阅读：269 作者：yanhengdoudou 栏目：数据库

现象描述

现在遇到应用里面有个递归查询的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

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 ;

可是DM7 不支持这种写法，但是Oracle 和pg 都支持。

处理方法

这种with 语句很难理解，但是dm7 有更好的写法

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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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":"CDh2","DTUpdatetime":"2019-09-23","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 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 , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '1' , ' 某个单位 1' , '0' , 2 , null , 1 , 21 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '1' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '2' , ' 某个单位 2' , '0' , 2 , null , 1 , 22 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '2' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '7aa5a78346e945d2993f7aaeb225bf32' , ' 权限单位一 ' , '0' , 2 , null , 1 , 23 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '7aa5a78346e945d2993f7aaeb225bf32' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '16562a3f03a946d99722ee56ca53b406' , ' 权限单位二 ' , '0' , 2 , null , 1 , 24 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '16562a3f03a946d99722ee56ca53b406' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '94b92e44607d431e895483e921e7642e' , ' 权限单位三 ' , '0' , 2 , null , 1 , 25 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '94b92e44607d431e895483e921e7642e' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '915f07d51c934eb48f1e39dcbb89f5b0' , ' 登录标识测试 ' , '0' , 2 , null , 1 , 26 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '915f07d51c934eb48f1e39dcbb89f5b0' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '5681cfc23ce84f4f8af2ca94f84bc13c' , ' 移动后登录标识单位 ' , '0' , 2 , null , 1 , 28 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-1"}' , 2 , null , '5681cfc23ce84f4f8af2ca94f84bc13c' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '10329188086' , 'dppatchdw 信息修改 ' , '0' , 1 , ' 简称 1' , 1 , 35 , '2019-09-17 13:53:08.181' , '{"CDh":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 2 , 'CDm1' , '10329188086' , 'CGbm1' , 'CDz1' , 'CYb1' );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '83714805570' , 'dppatchdw 信息修改 ' , '0' , 1 , ' 简称 1' , 1 , 36 , '2019-09-17 13:53:08.181' , '{"CDh":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 2 , 'CDm1' , '83714805570' , 'CGbm1' , 'CDz1' , 'CYb1' );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '56646573307' , 'dppatchdw 信息修改 ' , '0' , 1 , ' 简称 1' , 1 , 37 , '2019-09-17 13:53:08.181' , '{"CDh":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 2 , 'CDm1' , '56646573307' , 'CGbm1' , 'CDz1' , 'CYb1' );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '9' , ' 郝 1' , '0' , 2 , null , 1 , 39 , '2019-09-17 13:53:08.181' , '{"DTUpdatetime":"2019-09-17","CAdmin":"-2"}' , 2 , null , '9' , null , null , null );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '27083021230' , 'dppatchdw 信息修改 ' , '0' , 1 , ' 简称 1' , 1 , 47 , '2019-09-17 13:53:08.181' , '{"CDh":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 2 , 'CDm1' , '27083021230' , 'CGbm1' , 'CDz1' , 'CYb1' );

INSERT INTO "SYSDBA" . "T_TEST_1" VALUES ( '42792120463' , 'dppatchdw 信息修改 ' , '0' , 1 , ' 简称 1' , 1 , 48 , '2019-09-17 13:53:08.181' , '{"CDh":"CDh2","DTUpdatetime":"2019-09-17","CKhhm":"CKhhm1","nSftb":1,"CAdmin":"CAdmin1","CKhyh":"CKhyh2","CKhzh":"CKhzh2"}' , 2 , 'CDm1' , '42792120463' , 'CGbm1' , 'CDz1' , 'CYb1' );

commit ;

向AI问一下细节

如何改写带with的递归语句

现象描述

处理方法

猜你喜欢

最新资讯

相关推荐

相关标签