[Schema]
table_owner=TABLE_SCHEMA
table_name=TABLE_NAME
table_sql=select TABLE_SCHEMA,TABLE_NAME from information_schema.tables order by 1 DEsc
table_sql_filter=SELECT owner,table_name FROM dba_tables order by owner,table_name
table_open=1
function_owner=Owner
function_name=name
function_sql=select * from all_source
function_sql_filter=select distinct owner,name from all_source where type = 'FUNCTION' order by owner,name
function_open=0
index_owner=Owner
index_name=Index_name
index_sql=select * from all_indexes
index_sql_filter=select * from all_indexes order by owner,index_name
index_open=0
package_owner=Owner
package_name=name
package_sql=select distinct owner,name,text from all_sources
package_sql_filter=select distinct owner,name from all_source where type='PACKAGE' order by owner,name
package_open=0
packagebd_owner=Owner
packagebd_name=name
packagebd_sql=select * from all_source where type='PACKAGE BODY'  order by owner,name
packagebd_sql_filter=select distinct owner,name from all_source  where type='PACKAGE BODY'  order by owner,name
packagebd_open=0
sequence_owner=sequence_Owner
sequence_name=Sequence_name
sequence_sql=123
sequence_sql_filter=select * from dba_sequences  order by sequence_owner,sequence_name
sequence_open=0
procedure_owner=
procedure_name=name
procedure_sql=SELECT *FROM dbo.sysobjects AS v INNER JOIN dbo.syscomments c ON c.id = v.id  WHERE v.type = 'P'
procedure_sql_filter=select distinct owner,name from all_source where type='PROCEDURE'  order by owner,name
procedure_open=1
tablespace_owner=
tablespace_name=Tablespace_name
tablespace_sql=select * from dba_tablespaces  order by tablespace_name
tablespace_sql_filter=select * from dba_tablespaces order by tablespace_name
tablespace_open=0
trigger_owner=
trigger_name=name
trigger_sql=select * from sysobjects where xtype='TR'
trigger_sql_filter=select * from dba_triggers order by owner,trigger_name
trigger_open=1
user_owner=
user_name=NAME
user_sql=select * from  sysusers where sid is not null order by name
user_sql_filter=select username from all_users  order by username
user_open=1
source_owner=Owner
source_name=name
source_sql=select * from all_source where type='TYPE'  order by owner,name
source_sql_filter=select distinct (ISIN) from qry_exposure_all
source_open=0
view_owner=
view_name=name
view_source=text
view_sql=SELECT *FROM dbo.sysobjects AS v INNER JOIN dbo.syscomments c ON c.id = v.id  WHERE v.type = 'V'
view_sql_filter=sELECT owner,view_name from all_views order by owner,view_name
view_open=1
synonym_owner=Owner
synonym_name=Synonym_name
synonym_sql=select * from all_synonyms
synonym_sql_filter=select * from all_synonyms order by owner,synonym_name
synonym_open=0
role_owner=
role_name=name
role_sql=
role_sql_filter=  
role_open=0
TableDirect=0
ProcDirect=0
SysTables=0
Delimiter=;
Description=Microsoft SQL Server 2000/2005/2008/2012
Function_source=
Table_source=
Table space_owner=
Table space_name=
Table space_source=
Table space_sql=
Table space_open=0
Trigger_source=
Package_source=
Package body_owner=
Package body_name=
Package body_source=
Package body_sql=
Package body_open=0
Procedure_source=text
User_source=
Index_source=
Synonym_source=
Role_source=
Sequence_source=
User defined_owner=
User defined_name=
User defined_source=
User defined_sql=
User defined_open=0
[Plan]
Explain=delete SYSTEM.HTMLDB_PLAN_TABLE; explain plan into SYSTEM.HTMLDB_PLAN_TABLE for %s;
View=select * from SYSTEM.HTMLDB_PLAN_TABLE;
