[Schema]
table_owner=owner
table_name=Table_name
table_sql=SELECT * FROM dba_tables order by owner,table_name
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 order by owner,name
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 order by owner,index_name
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 where type='PACKAGE'  order by owner,name
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' and owner = '%username%' 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=select * from dba_sequences  order by sequence_owner,sequence_name
sequence_sql_filter=select * from dba_sequences  order by sequence_owner,sequence_name
sequence_open=0
procedure_owner=Owner
procedure_name=name
procedure_sql=select distinct owner,name from all_source  where type='PROCEDURE'  order by owner,name
procedure_sql_filter=select distinct owner,name from all_source where type='PROCEDURE'  order by owner,name
procedure_open=0
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=Owner
trigger_name=Trigger_name
trigger_sql=select * from dba_triggers order by owner,trigger_name
trigger_sql_filter=select * from dba_triggers order by owner,trigger_name
trigger_open=0
user_owner=
user_name=USERNAME
user_sql=select * from all_users order by username
user_sql_filter=select username from all_users  order by username
user_open=0
source_owner=Owner
source_name=Table_name
source_sql=select * from dba_tables where owner = '%username%'
source_sql_filter=select distinct (ISIN) from qry_exposure_all
source_open=0
view_owner=Owner
view_name=View_name
view_source=
view_sql=sELECT * from all_views order by owner,view_name
view_sql_filter=sELECT owner,view_name from all_views order by owner,view_name
view_open=0
synonym_owner=Owner
synonym_name=Synonym_name
synonym_sql=select * from all_synonyms order by owner,synonym_name
synonym_sql_filter=select * from all_synonyms order by owner,synonym_name
synonym_open=0
role_owner=
role_name=Role
role_sql=
role_sql_filter=   
role_open=0
TableDirect=1
ProcDirect=0
SysTables=1
Delimiter=;
Function_source=
Table_source=
Tablespace_source=
Trigger_source=
Package_source=
packagebd_source=
Procedure_source=
User_source=
index_source=
Synonym_source=
Role_source=
Sequence_source=
Source_source=
Description=Direct access (For all tables)
Table space_owner=
Table space_name=
Table space_source=
Table space_sql=
Table space_open=0
Package body_owner=
Package body_name=
Package body_source=
Package body_sql=
Package body_open=0
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;
