1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
QSscintilla port:
* More integrated QScintilla features (toMarkedText class)
The toMarkedText class is still using its own version of the search/replace
functionality from the pre-QScintilla times. Since QextScintilla has powerful
search mechanism (regex support etc) - this needs to be integrated and the old
one got rid of.
- fix insert(str, select). see toMarkedText::insert
* Finish implementation of syntax colouring editor component (toHighlightedText class)
Code completion in SQL editor (using QextScintillaAPIs class), better integration
with lexer class (QextScintillaLexer). We also probably need to override
QextScintillaLexerSQL to better suit TOra purposes.
* Subtask from previous - integrate toSyntaxAnalyzer with QextScintillaLexer (or our
subclass of it). This is needed to because toSyntaxAnalyzer used all over TOra to
do validity checks of SQL, parameter parsing and other related things (not just
syntax colouring). Hence it would make much more sense to integrate it with
QextScintillaLexer where the latter can take keyword lists out of toSyntaxAnalyzer.
* Syntax colouring configuration options (toSyntaxSetup class and UI dialog)
This has to be reimplemented to use QextScintillaLexer class instead of toSyntaxAnalyzer.
* PL/SQL debugging (toDebugText class)
This has to be updated to use marker facilities provided by QextScintilla
Previous TODO:
Extended functionality:
* SQL Browser
Add information about partitions.
Modify tables
Caching/Nocaching
ALTER TABLE ... CACHE/NOCACHE
Deallocate Unused Space
ALTER TABLE ... DEALLOCATE UNUSED
Add columns
Remove columns
Add constraints
Remove constraints
Rename table (And everything else)
ALTER TABLE ... RENAME TO ...
DB Links
Libraries
Materialized Views
Dimensions
Partitions
* toResultContent improvements
Make it possible to reorder columns in toResultContent.
Add tooltips like in result lists.
* Editor improvements
CVS support (Or whatever this is called in windows).
PL/SQL doc (Like JavaDoc).
Synchonize editors that edit the same file.
* Debugger
Don't lock during execution
Support for Oracle 7
Support for multiple open editors
Attaching to remote debugging session
Support for one referential cursor output variable
* Full support for Oracle 9i.
Support for undo tablespaces.
Support for list partitions in extractor
* Add consumer group settings to security manager.
* Extract grants from objects.
* Implement extract of temporary tables.
* Implement migration, resize and report in toExtract.
* Lots of more template texts including SQL syntax.
* Ability to change/move redofiles.
* Go through changes in DDL::Oracle and incorporate in toExtract.
* Printing of toResultItems.
* Different highlighter depending on connection.
* Default names to listen to in alert.
* Make menues and toolbuttons work for QLineEdit & QComboBox.
* Use object cache in script object lists.
* Optionaly drop before create in toExtract.
* Ability to modify rollback segment.
* Ability to drop tablespaces.
* Information about controlfiles in tuning.
* Use object cache in browser if possible.
* Add support to run profiling in background.
* Track session statistics while profiling.
* Proxy connection provider.
* Store worksheet statistic on save session.
* Configure key bindings.
* Use QTable to display the result in the worksheet.
* Improved visualisation of any list and any columns.
* Session:Long operations(v$session_longops)
* Archive log info
* Rollback:Shrink rollback segment(ALTER ROLLBACK SEGMENT TO {value})
* Separate refresh of session info and session list.
* Add auto extend information to the storage manager.
* Add copy datafile/tablespace in storage manager.
* Add warning when changing to Default Storage when disabled in modify tablespace in storage.
* Enable copy in main window on lists.
* Explain plan without execute in worksheet.
* Option to select newline format on saved text.
* Make legacy CTRL+Shift etc keyboard bindings available.
* Don't display statements not in the SGA in the SGA trace.
* Include public objects in script tool.
* Option wether tool button open new window or an already open tool.
* Include status of code objects in browsertool.
* Implement printing of text view.
* Plugin interface to alerttypes.
* Handle AQ_ priviledges correctly in security manager (Using DBMS_AQADM package).
* Easier to grant all priviledges to a user.
* Save column order of open tools when saving/restoring session.
* Remember settings in print dialog.
* Make it posible to configure CSV separator/delimiter in chartmanager.
* Save state of SQL output window.
* Make session waitstate analyzer also keep track of what SQL is executed.
* Don't update tabs which never can be updated in session manager.
* Add tooltips in waitstate charts to display waitstate name and value.
* Make default schema any an option.
* Initially sort descending on columns in SGA trace.
New tools:
* SQL Builder?
* Visual reverse engineering of DB.
* Change impact analyzing tool.
* Alert log viewer.
* Recent events:
* Number of redo switches
* Users added withing 30 days
* Roles added withing 30 days
* Datafiles added within 30 days
* Objects added within 30 days
* Objects edited within 30 days
* SQL*Loader controlfile generator.
* Replication manager.
|