Question

我想用jquery或者JS实现这样一个功能怎么实现，求大神

Answer 1

再比如下面的语句，有分组运算：
SELECT * FROM local_tab a,remote_big_tab@remote b,(SELECT max(object_id) object_id FROM remote_small_tab@remote c GROUP BY c.object_type) c
WHERE b.object_id=c.object_id AND a.object_type=b.object_type;

执行计划
----------------------------------------------------------
Plan hash value: 2122363341
-----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Inst |IN-OUT|
-----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2321K| 431M| 2144 (3)| 00:00:26 | | |
|* 1 | HASH JOIN | | 2321K| 431M| 2144 (3)| 00:00:26 | | |
|* 2 | HASH JOIN | | 1412 | 135K| 1836 (3)| 00:00:23 | | |
| 3 | VIEW | | 11 | 143 | 9 (12)| 00:00:01 | | |
| 4 | REMOTE | | | | | | REMOTE | R->S |
| 5 | REMOTE | REMOTE_BIG_TAB | 1479K| 119M| 1819 (2)| 00:00:22 | REMOTE | R->S |
| 6 | TABLE ACCESS FULL| LOCAL_TAB | 73985 | 7008K| 296 (1)| 00:00:04 | | |
-----------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("A"."OBJECT_TYPE"="B"."OBJECT_TYPE")
2 - access("B"."OBJECT_ID"="C"."OBJECT_ID")

Remote SQL Information (identified by operation id):
----------------------------------------------------
4 - EXPLAIN PLAN SET STATEMENT_ID='PLUS5801659' INTO PLAN_TABLE@! FOR SELECT
MAX("A1"."OBJECT_ID") FROM "REMOTE_SMALL_TAB" "A1" GROUP BY "A1"."OBJECT_TYPE" (accessing
'REMOTE' )
5 - SELECT "OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJECT_TYP
E","CREATED","LAST_DDL_TIME","TIMESTAMP","STATUS","TEMPORARY","GENERATED","SECONDARY" FROM
"REMOTE_BIG_TAB" "B" (accessing 'REMOTE' )

通过计划看出，将远程表进行分组运算后，传输给本地库，然后大表传输给本

Answer 2

你能不逗么，功能都不说

Answer 3

你的问题都没有给我们看到我们怎么知道你的需求是什么呢

Answer 4

问问题不要当误大家时间和流量，

Answer 5

什么功能啊？