[Schema]
TableDirect=1
SysTables=1
ProcDirect=0
Delimiter=;
Description=ClearDB  (For all tables)
Function_owner=Owner
Function_name=name
Function_source=
Function_sql=select * from all_source order by owner,name
Function_open=0
Table_owner=owner
Table_name=Table_name
Table_source=
Table_sql=SELECT * FROM dba_tables order by owner,table_name
Table_open=1
Table space_owner=
Table space_name=
Table space_source=
Table space_sql=
Table space_open=0
Trigger_owner=Owner
Trigger_name=Trigger_name
Trigger_source=
Trigger_sql=select * from dba_triggers order by owner,trigger_name
Trigger_open=0
Package_owner=Owner
Package_name=name
Package_source=
Package_sql=select distinct owner,name,text from all_sources where type='PACKAGE'  order by owner,name
Package_open=0
Package body_owner=
Package body_name=
Package body_source=
Package body_sql=
Package body_open=0
Procedure_owner=Owner
Procedure_name=name
Procedure_source=
Procedure_sql=select distinct owner,name from all_source  where type='PROCEDURE'  order by owner,name
Procedure_open=0
User_owner=
User_name=USERNAME
User_source=
User_sql=select * from all_users order by username
User_open=0
View_owner=Owner
View_name=View_name
View_source=
View_sql=sELECT * from all_views order by owner,view_name
View_open=0
Index_owner=Owner
Index_name=Index_name
Index_source=
Index_sql=select * from all_indexes order by owner,index_name
Index_open=0
Synonym_owner=Owner
Synonym_name=Synonym_name
Synonym_source=
Synonym_sql=select * from all_synonyms order by owner,synonym_name
Synonym_open=0
Role_owner=
Role_name=Role
Role_source=
Role_sql=
Role_open=0
Sequence_owner=sequence_Owner
Sequence_name=Sequence_name
Sequence_source=
Sequence_sql=select * from dba_sequences  order by sequence_owner,sequence_name
Sequence_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;
