Question

jquery怎么实现关系图的绘制

Answer 1

比如下面语句含有子查询：

SELECT * FROM local_tab a,remote_big_tab@remote b,remote_small_tab@remote c
WHERE b.object_id=c.object_id AND a.object_type=b.object_type
AND a.object_id IN (SELECT object_id from sub);
执行计划
----------------------------------------------------------
Plan hash value: 252158753
----------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Inst |IN-OUT|
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 79M| 20G| 3843 (46)| 00:00:47 | | |
|* 1 | HASH JOIN | | 79M| 20G| 3843 (46)| 00:00:47 | | |
| 2 | REMOTE | REMOTE_SMALL_TAB | 5320 | 431K| 8 (0)| 00:00:01 | REMOTE | R->S |
|* 3 | HASH JOIN | | 172M| 31G| 2978 (31)| 00:00:36 | | |
|* 4 | HASH JOIN | | 5260 | 565K| 303 (2)| 00:00:04 | | |
| 5 | SORT UNIQUE | | 5320 | 69160 | 5 (0)| 00:00:01 | | |
| 6 | TABLE ACCESS FULL| SUB | 5320 | 69160 | 5 (0)| 00:00:01 | | |
| 7 | TABLE ACCESS FULL | LOCAL_TAB | 73985 | 7008K| 296 (1)| 00:00:04 | | |
| 8 | REMOTE | REMOTE_BIG_TAB | 1479K| 119M| 1819 (2)| 00:00:22 | REMOTE | R->S |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("B"."OBJECT_ID"="C"."OBJECT_ID")
3 - access("A"."OBJECT_TYPE"="B"."OBJECT_TYPE")
4 - access("A"."OBJECT_ID"="OBJECT_ID")

Remote SQL Information (identified by operation id):
----------------------------------------------------

2 - SELECT "OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJECT_TYPE","CREATED",
"LAST_DDL_TIME","TIMESTAMP","STATUS","TEMPORARY","GENERATED","SECONDARY" FROM "REMOTE_SMALL_TAB"
"C" (accessing 'REMOTE' )

8 - SELECT "OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJECT_TYPE","C
REATED","LAST_DDL_TIME","TIMESTAMP","STATUS","TEMPORARY","GENERATED","SECONDARY" FROM
"REMOTE_BIG_TAB" "B" (accessing 'REMOTE' )

Answer 2

有一个jquery关系图的插件..额 在哪里下载的忘了 你搜索下.