CREATE TABLE TABLE_A(
ID VARCHAR(20),
NAME VARCHAR(20),
SEX VARCHAR(20),
AGE VARCHAR(20),
LOADDATE VARCHAR(20)
);
CREATE TABLE TABLE_B(
ID VARCHAR(20),
NAME VARCHAR(20),
SEX VARCHAR(20),
AGE VARCHAR(20),
LOADDATE VARCHAR(20)
);
TRUNCATE TABLE TABLE_A;
TRUNCATE TABLE TABLE_B;
INSERT INTO "ORA_OAUTH"."TEST_A" ("ID", "NAME", "SEX", "STUDENT_NO", "LOADDATE", "ROWID") VALUES ('1', '小明', '男', '27', '20200520', 'AAACOKAAEAAAAWJAAA');
INSERT INTO "ORA_OAUTH"."TEST_A" ("ID", "NAME", "SEX", "STUDENT_NO", "LOADDATE", "ROWID") VALUES ('2', '小红', '女', '28', '20200520', 'AAACOKAAEAAAAWJAAB');
INSERT INTO "ORA_OAUTH"."TEST_A&#